I have been using Crystal report XI release 2 Dev Edn. and SQL Server 2000 in an application developed in VB6. I use the RDC to call the report. The report works fine in the development system. I have designed set up using installshield. I have included all the merge modules as required.
I installed the application in another machine. The installation gave no problem. SQL Server 2K was also installed separately and the database created.
Now when I run my reports within my application the error message pops up "Failed to open connection. Database Vendor Code 17"
My development machine and test machine have similar environment. what works in development environment fails in test environment.
How can I overcome this problem?
thanks in advance