Skip to Content
0
Former Member
Jan 03, 2012 at 10:10 AM

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

53 Views

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