Authentication issue with BDE and MSSQL 7 on Windows XP SP2 machine
Posted on 2004-12-01
I'm having difficulty with BDE 5.01 database connectivity using the native MSSQL driver connecting to a MSSQL 7 database on a Windows XP SP2 machine. It's not passing the Windows authentication user/pass credentials to MSSQL correctly. If I use an ODBC driver connection to the same SQL Server then I have no problem. I believe that the issue may have something to do with the MSSQL 7 client install on that machine not populating the ntwdblib.dll file into the C:\Windows\System32 directory (although the DB Library Options Tab of the SQL Client shows it to be there). I've manually placed the file there (tried the following versions: 2000.80.194.0 and 19188.8.131.52) and it didn't help. I've uninstalled/reinstalled the MSSQL client and still the ntwdblib.dll is not being populated on install. I've thought about reinstalling MDAC since I've read that the ntwdblib.dll file needs some of its components, but have had trouble with this in Win XP SP2 (the exact same version downloaded from the MS website will give an incompatibility error). The Windows firewall remains disabled.
Any constructive help is appreciated.