OI and SQLserver (OpenInsight Specific)
At 23 FEB 1998 08:23:28AM bwk@akribi.se wrote:
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,
OI 3.2 SQLServer 6.5 … how does OI determine which protocol to use when communicating with SQLServer over native drivers ??
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).
r there any differences between W3.11 and W95 ??
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