
OLEDB connection to SQL Server 2000 fails - 20599 error
Hi all;
I've been battling the same connectivity issues as a lot of people. Can't
use the native SQL connection with the ntwdblib.dll anymore. Don't want to
proliferate ODBC DSNs to every workstation. So I thought I had the solution
with OLE DB and the P2SOLEDB.dll.
I'm using VB 6 with the crystl32.ocx and Crystal Reports 8.5 against SQL
2000 with NT authentication. My workstation is NT 4.0. Some of the
workstations I'm deploying to are NT 4.0, others Windows 2000.
I'm getting the error on an NT 4.0 machine. I tried the suggested fix on
the Crystal KB to set the Connect property of the Crystal Report control to
"UID=<<Use IntegratedSecurity>>" but that didn't seem to have any effect.
I've looked at the dependencies of the p2soledb.dll and all the required
files are on the target machine.
Anyone have any ideas?
TIA
Marcia