Error 20599 using SQL Server Authentication

[Geffren]

The problem I have is after my VB6 project has been distributed to a Windows 95 PC.
The Report works fine in the VB development environment and when run independently in Crystal Reports.
Once packaged using the Package Deployment Wizard and installed on to a Windows 95 machine,
I attempt to run a report and Crystal Reports gives me a blank database error message and closes down,
the application then returns :-

20599 Cannot Open SQL Server.

The VB uses the Connection property of the OCX, using SQL Server Authentication ....

"DSN=dsnName;UID=userid;PWD=password;DSQ=dsqname;"

The report uses the pdsoledb.dll database driver, the table names in the Set Location window have had their db etc removed leaving only the table name.

e.g. DatebaseName.dbo.TableName changed to TableName

I am using VB6(SP5), SQL Server 2000(SP3), Crystal Reports 8.5 and developing on a Windows 2000(SP3) PC.

I have checked the installation files, to the best of my knowledge (after checking the Crystal site)
all of the DLL files have been included. But I could be wrong!

The package also contains Mdac 2.7 and Dcom 95.

I must have missed something or am stupid, not sure which one.

Any help or suggestions would be appreciated.

 

[SurfingGecko]

Try this --

.Connect = "DSN=servername;UID=userid;PWD=password;DSQ=dsqname"

Notice the DSN is servername and not a DSN. You using OLEDB to connect so this should work for you.

Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease

 

[Geffren]

Thanks SurfingGecko, have managed to solve the problem.

crpe32.dll was out of date. Installing version 8 or above fixes the problem.