Link to home
Start Free TrialLog in
Avatar of FAC
FAC

asked on

Run Time Error 20599: cannot open SQL server

With VB6, how to connect a SQL server database using MSDAO to crystal reports 7.0
The string connection to the sql database northwind is:

Provider=SQLOLEDB.1;User ID=sa;Initial Catalog= northwind;Data Source=servidor;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=FAC;Use Encryption for Data=False;Tag with column collation when possible=False

I use the crystal report control. Of course, I have no problem, if the report is compiled in the server where the program will run. If not, occurs then following error:
Run Time Error 20599: cannot open SQL server


Thanks for any help.
Avatar of FAC
FAC

ASKER

It is not MSDAO, is MSADO, obviously.
ASKER CERTIFIED SOLUTION
Avatar of Alon Hirsch
Alon Hirsch
Flag of Australia image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ayufans
ayufans
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

- answered by alonhirsch

Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

ayufans
Cleanup Volunteer
Avatar of modulo
modulo
Finalized as proposed

modulo

Community Support Moderator
Experts Exchange
Avatar of Dhanushka Siriwardhana
Dhanushka Siriwardhana
I faced this issue on Oracle Database environment.
Problem is on ODBC connectivity section.Please create ODBC connectivity admin,Domain admin or under relevant user permissions.
If you need further assistant please email to me.I like to help you any IT network related issues.
Dhanushka.Siriwardhana@yahoo.com