We help IT Professionals succeed at work.

New podcast episode! Our very own Community Manager, Rob Jurd, gives his insight on the value of an online community. Listen Now!

x

Failed Databse Connection [Databse Vendor Code 17]

1,311 Views
Last Modified: 2012-05-05
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
Comment
Watch Question

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
DO you change the database location in the application?

mlmcc
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
How do you connect to the database?

mlmcc

Author

Commented:
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
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Forced accept.

Computer101
EE Admin
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.