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.