Link to home
Create AccountLog in
Avatar of Commando
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
Avatar of Mike McCracken
Mike McCracken

DO you change the database location in the application?

mlmcc
How do you connect to the database?

mlmcc
Avatar of Commando

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.setdatasource rs
report.readrecords

then this report is attached to the viewer to display

regards
commando
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Forced accept.

Computer101
EE Admin