Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Failed to open the connection. Details: [Database Vendor Code: 53 ]

I'm upgrading one of our applications from Visual Studio 2005 to 2010. In the process I'm also switching our reports to run using Stored Procedures instead of Tables/Views. Everything runs fine on development machines after all the migration work. On the server however, it does not work. And I am getting the error message ""

Server is Windows 2003 Server 32 bit. And yes, I have installed the latest runtimes version 13.0.2000.0 on the server. There have been no other changes on the server other than to switch the target framework on the website in question from .net 2 to .net 4, and then to modify the web.config file to remove references to the older Crystal Reports and replace with references to the newer version.

I've seen many other threads on this "failed to open the connection" errors but none of them are my problem except there is one post that remains unanswered where someone had the same Database Vendor Code 53. I don't know what that error means, spent a considerable amount of time researching that before asking this question.

Lastly, it appears that this error only happens when the report is pulling data from a Stored Procedure rather than Tables/Views. If I re-copy the previous reports, they still work.

The ODBC drivers haven't changed, nor should they. They are fully up to date on that server machine.

I can't think of anything else that would be indicative of anything other than this is a bug. Here is the error text as it shows up in the event log:

Event code: 3005

Event message: An unhandled exception has occurred.

Event time: 12/7/2011 3:49:50 PM

Event time (UTC): 12/7/2011 11:49:50 PM

Event ID: 38ce5b5487984e8aa8d2b84493d859a8

Event sequence: 17

Event occurrence: 1

Event detail code: 0

Application information:

Application domain: /LM/W3SVC/739252194/Root-1-129677751941252500

Trust level: Full

Application Virtual Path: /

Application Path: D:\Websites\ACE5\Clients\TST\

Machine name: ACE1

Process information:

Process ID: 5436

Process name: w3wp.exe

Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:

Exception type: InternalException

Exception message: Failed to open the connection.

Failed to open the connection.

Details: [Database Vendor Code: 53 ]

Failed to open the connection.

Details: [Database Vendor Code: 53 ]

Failed to open the connection.

PackSlipTST0 {638463B4-2196-492A-BD6E-9D82CB1862D5}.rpt

at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)

at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)

at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)

at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options)

at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToHttpResponse(ExportOptions options, HttpResponse response, Boolean asAttachment, String attachmentName)

at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToHttpResponse(ExportFormatType formatType, HttpResponse response, Boolean asAttachment, String attachmentName)

at Distribution_PackingSlips_default.ExportPackingSlips(String CrystalReportPath, Boolean UseStoredProcedure)

at Distribution_PackingSlips_default.Page_Load(Object sender, EventArgs e)

at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)

at System.Web.UI.Control.OnLoad(EventArgs e)

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Failed to open the connection.

Failed to open the connection.

Details: [Database Vendor Code: 53 ]

Failed to open the connection.

Details: [Database Vendor Code: 53 ]

Failed to open the connection.

PackSlipTST0 {638463B4-2196-492A-BD6E-9D82CB1862D5}.rpt

at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)

at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)

Former Member
Not what you were looking for? View more on this topic or Ask a question