Error Message Failed To Open The Connection. .rpt
The Report Viewer / Failed to open the connection Failed to open the connection Submitted by steve on Sun, 2008-03-16 05:29 I'm evaluating this product, and I came across an issues. When I tried to load my report, there is a message box that says, "Crystal Reports Windows Forms Viewer," and it displays the message, "failed to open the connection." What am I doing wrong. I like the product interface, and the price is good compared to a full install of Crystal Reports. Please help me with this. Forums:The Report Viewer Log in or register to post comments Submitted by rpt on Sun, 2008-03-16 05:44 Re: Failed to open the connection Hi Steve, This is a message from the Crystal Reports component saying that it can not connect to the database or data source for the report. To resolve, you must first know what database the report accesses. Then you need to make sure the client computer has the ability to access that data source. Often, the easiest way to set up this source is using ODBC. You can create a new connection from the Control Panel in Windows. From the Control Panel find Administrative Tools. From there, you will see Data Sources. You should add your data source. I've seen other cases that cause people trouble. For instance, one person was creating a report with an Excel spreadsheet as a data source, and that spreadsheet was installed on his local machine. When other users would try to open the report, they would get this message. In that case, the reason was the client PC's did not have access to the spreadsheet. This could also happen if different PC's access the spreadsheet through a different path. I've also heard about this error being caused by an error in a report. I don't know the full details on that one, but you can check. This message comes from the Crystal Reports, and is not part of anything we programmed; I hope we would be more clear. Anyway, if you had a full install of Crystal Reports on that system, it would get the same message. So, know the name of the data source that the report is tryi
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Advanced ASP.NET/Crystal Reports/Crystal: Failed to open Connection Crystal: Failed to open Connection RSS 16 replies Last post Apr 11, 2011 11:25 PM by necro_mancer ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply netfreak9 None 0 Points 23 Posts Crystal: Failed to open Connection Jun 08, 2006 04:34 AM|netfreak9|LINK Hi, I am on the verge of pulling my hair off on this one. I've got web http://www.thereportviewer.com/forum/report-viewer-product-discussion/report-viewer/failed-open-connection reports built on Crystal XI and they work absolutely fine on my Windows XP machine. I now transfer the web application to my Windows 2003 Enterprise Production Server and the web application is still running fine except all my reports keep giving the following error: Failed to open the connection. Details: [Database Vendor Code: 17 ] Failed to open the connection. http://forums.asp.net/t/997655.aspx?Crystal+Failed+to+open+Connection C:\WINDOWS\TEMP\{ADB8090C-40ED-499D-88E3-915E23B0C5C3}.rpt Details: [Database Vendor Code: 17 ] I have the latest service packs for crystal & windows. The Business Objects website doesn't talk about this error. Thanks, Irfan. Reply jportelas Member 637 Points 591 Posts Re: Crystal: Failed to open Connection Jun 09, 2006 08:24 AM|jportelas|LINK What database are you using? SQL Server (2000 or 2005), Oracle? Reply netfreak9 None 0 Points 23 Posts Re: Crystal: Failed to open Connection Jun 10, 2006 12:47 AM|netfreak9|LINK Hi jportelas, I am using SQL Server 2000 and when I run the reports in Crystal, they run fine. I am unable to understand what is the cause of this problem. Please help. Thanks, Irfan. Reply netfreak9 None 0 Points 23 Posts Re: Crystal: Failed to open Connection Jul 12, 2006 11:01 AM|netfreak9|LINK I resolved the issue finally. Something which is pretty wierd. Do the following steps: 1. Open the report in the CR XI designer. 2. Select Database -> Set Datasource Location. 3. Set Datasource Location window will appear and in the replace with section connect to the database and replace these tables
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of http://stackoverflow.com/questions/28119692/crystal-reports-failed-to-open-the-connection this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up error message Crystal Reports failed to open the connection up vote 0 down vote favorite I am developing a desktop software which is creating proposals and invoices. I am storing my database (MySql) in a remote server. Everything is working perfectly fine in my PC which i am using for coding. On client machine I can add,update and delete records without any problem. But when error message failed i try to open a record in then I am facing with an error below. I was created the report in VB.NET but when I face with the error than I opened the rpt file in Crystal Reports XI Release 2 and updated data source location, verified database and save the file. Some part of my code is : ElseIf Me.Text = "Tekliflere Gözat" Then Form16.Text = "Teklif Detayları:" Dim strReportPath As String Dim rptDoc As CrystalDecisions.CrystalReports.Engine.ReportDocument strReportPath = My.Application.Info.DirectoryPath & "\Teklif.rpt" rptDoc = New ReportDocument rptDoc.Load(strReportPath) rptDoc.SetDatabaseLogon("USER_NAME", "PASSWORD", "SERVER_IP", "DB_NAME") Form16.CrystalReportViewer1.ReportSource = rptDoc Form16.CrystalReportViewer1.SelectionFormula = "{teklif1.teklifno} =" & ListView1.SelectedItems(0).Text Form16.CrystalReportViewer1.Refresh() Form16.CrystalReportViewer1.RefreshReport() Form16.Show() Me.Close() Could you please advise. Thank you. Regards Oguz vb.net crystal-reports-xi share|improve this question asked Jan 23 '15 at 22:21 Ardeth 40110 Lookup how to apply TableLogonInfo. And, if it is at all possible, dump crystal Reports. This is just the first of many problems you will have. –Crowcoder Jan 24 '15 at 2:25 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted I've found the solution. But first have to look at the casue. W