?
Solved

Failed Databse Connection [Databse Vendor Code 17]

Posted on 2007-09-30
6
Medium Priority
?
1,282 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
0
Comment
Question by:Commando
  • 3
5 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 19987738
DO you change the database location in the application?

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 19987743
How do you connect to the database?

mlmcc
0
 

Author Comment

by:Commando
ID: 19987925
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
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 19988652
0
 
LVL 1

Expert Comment

by:Computer101
ID: 20246380
Forced accept.

Computer101
EE Admin
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question