[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]
==== OI and SQLserver (OpenInsight Specific) ====
=== At 23 FEB 1998 08:23:28AM bwk@akribi.se wrote: ===
{{tag>"OpenInsight Specific"}}
OI 3.2 SQLServer 6.5
how does OI determine which protocol to use when communicating with
SQLServer over native drivers ??
r there any differences between W3.11 and W95 ??
/Bengt
----
=== At 23 FEB 1998 10:28AM Cameron Revelation wrote: ===
Bengt,
[i]OI 3.2 SQLServer 6.5 ... how does OI determine which protocol to use when communicating with SQLServer over native drivers ??[/i]
It does not have access to protocol information; protocols are hidden behind the db-library API (aka w3dblib.dll). My understanding is that the protocols are determined by the availability of certain DLL's (e.g. dbnmp3.dll).
[i]r there any differences between W3.11 and W95 ??[/i]
No. It works the same way (it uses w3dblib.dll) regardless of what Windows version it is operating on, including 3.x, 95, and NT.
Cameron Purdy
info@revelation.com
----
=== At 23 FEB 1998 04:33PM bwk@akribi.se wrote: ===
the reason why I'm asking is that we had a problem a few weeks ago,
where ISQLW communicated just fine .. but OI didn't ....
someone checked how the programs were communicating, ISQLW was
using TCP/IP, but OI was using NETBIOS. Both protocols were installed,
and all the netdrivers for SQLServers were available, however, the
server was only communicating using TCP/IP. This same person checked
the protocol stack in the control panel, and found that NETBIOS was
installed as the preferred protocol for this client ....
----
=== At 23 FEB 1998 05:40PM Cameron Revelation wrote: ===
Bengt,
What you described can happen if one of the following is true:
1) The ISQLW program and its communications libraries are installed in a directory that is not in the search path
2) There are multiple copies of the SQL Server libraries in the path, such as w3dblib.dll, dbnmp3.dll, ....
Cameron Purdy
Revelation Software
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=0CFDC6EF319DD62F852565B400498F94|View this thread on the forum...]]