Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error 20599 using SQL Server Authentication

Status
Not open for further replies.

Geffren

Programmer
Jul 10, 2003
2
GB
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.

 
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
Home of Crystal Ease
 
Thanks SurfingGecko, have managed to solve the problem.

crpe32.dll was out of date. Installing version 8 or above fixes the problem.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top