"Cannot Connect to SQL Server" Error when Running Crystal reports from VB6 program
Posted on 2006-06-28
We have a program written in VB6 that connects to a DB2 database and generates a crystal report based on user input. The problems occurs after a new install, when the program attempts to write a crystal report, it gives the error message "Cannot Connect to SQL Server" I believe the problem is somewhere in the .dll files that control crystal reports, but I do not know how to fix the problem. The program does in fact connect to the DB2 database because it runs a SELECT statement on the database when the program starts. There are several computers that the program runs fine on, so I know the connection string is correct. Is there a tool I can use that wil make sure the correct .dll files are in place or is the problem somewhere else?
Thanks, Any help is greatly appreciated.