Commando
asked on
Failed Databse Connection [Databse Vendor Code 17]
Dear all,
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
Commando
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
Commando
How do you connect to the database?
mlmcc
mlmcc
ASKER
Dear mlmcc
The name of the sql databse server changes . The record set is created and the recordset is passed to the report using
report.databse.setdatasour ce rs
report.readrecords
then this report is attached to the viewer to display
regards
commando
The name of the sql databse server changes . The record set is created and the recordset is passed to the report using
report.databse.setdatasour
report.readrecords
then this report is attached to the viewer to display
regards
commando
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
mlmcc