Failed Databse Connection [Databse Vendor Code 17]

Posted on 2007-09-30
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

Question by:Commando
    LVL 100

    Expert Comment

    DO you change the database location in the application?

    LVL 100

    Expert Comment

    How do you connect to the database?


    Author Comment

    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

    then this report is attached to the viewer to display

    LVL 100

    Accepted Solution

    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    730 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now