We took the TextCopy.cpp program supplied with SQL Server and set it for
integrated security using the following code.
// fill the login record
DBSETLUSER (pLoginRec, strLogin); // set the login
DBSETLPWD (pLoginRec, strPassword); // set the password
DBSETLAPP (pLoginRec, "textcopy"); // set the app name
DBSETLHOST (pLoginRec, "textcopy"); // set the host name
// To use secure, or trusted, connection, uncomment the following
line.
DBSETLSECURE (pLoginRec);
// attempt to connect to SQL Server
PDBPROCESS pDbproc;
pDbproc = dbopen (pLoginRec, strServer)
The database we are connecting to is MSDE 2000. The program works for me
on my workstation. It does not work for
me on another workstation. We
tried eight workstations and it works on half of them. The user account
doesn't appear to matter, but rather the workstation. We checked the
registry, the machines are all slightly different on the
MSSQLServer\Client\ConnectTo. We tried to make the keys the same as one
of the working workstations, but it did not help. On the machines that
it did not work on, it appears that the program is trying to use SQL
Server logins rather than integrated logins.
We also noticed that the systems that work have ntwdblib.dll
(2000.80.194.0) with out National Instruments Test Stand OR ntwdblib.dll
(1998.11.13.0) with National Instruments Test Stand. The systems that do
not work have ntwdblib.dll (2000.80.194.0) with National Instruments
Test Stand. It appears that the SQL tools installs ntwdblib.dll and
National instruments Test Stand will install the 1998 version if it
doesn't exist. The problem appears to actually be because of a different
library call
ed by ntwdblib.dll.
Does anyone have any ideas/suggestions?
TIA
Rich Hilt
