Skip to Content
author's profile photo Former Member
Former Member

Crystal Report 13 Visual Studio 2010 SQL Server 2008 R2 ODBC Problem

Hi Everybody,

I am new in Crystal Report.

I developed a web application in Visual Studio 2010, and my Database is SQL Server 2008 R2.

I created reports using Crystal Report 13 in Visual Studio and my Operating System is Windows 7 32-Bit.

I used ODBC Connection System DNS for my application.

It is running fine even after Hosting on my local PC.

But it creates problem when hosted on my Team Leader PC and Test Server.

Their Configurations are same but only difference is "SQL Server 2008" Not R2

The Error I am getting is "Failed to open the connection".

When I Host the same on my another team member PC, I am getting the error like

"Failed to open the connection. Details: [Database Vendor Code: 4060 ] Database Connector Error: ' [Database Vendor Code: 4060 ]' Failed to open the connection. Failed to open the connection. TestVr {CE268132-D2BD-43EC-BE45-0BCD847FBCDA}.rpt Details: [Database Vendor Code: 4060 ]"

I tried various solution to fix this bug.

But i am unable to do this and not getting any idea to fix this issue.

If anyone can guide I will be thankful to him.

All suggestions are appreciable.

Thank you

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jan 03, 2012 at 02:01 PM

    Moved to .NET SDK forum.

    Install and use the MS SQL 2008 Client tools and the SQL Native 10 driver in your DSN.

    Don

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 03, 2012 at 03:15 PM

    Hi,

    Please use the top right search box. for ex below search which will return many useful kb's, articlea and forum threads where simillar issues are discussed.

    [http://www.sdn.sap.com/irj/scn/advancedsearch?query=failedtoopentheconnection|http://www.sdn.sap.com/irj/scn/advancedsearch?query=failedtoopentheconnection]

    Most probably the issue is missing database client driver / provider.

    Install the driver used to connect the rpt to the db on the server and then create a 32 bit DSN with the same name as the dev machine..

    Hope this helps,

    Bhushan.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.