Failed To Open Connection Error In Crystal Reports
Contents |
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 crystal reports failed to open the connection database vendor code 17 Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply netfreak9 None 0 Points crystal reports failed to open the connection ora 12154 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 crystal reports viewer failed to open the connection on this one. I've got web 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 crystal reports windows form viewer failed to open the connection 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. 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
Failed To Open The Connection Crystal Reports C#
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 with the tables in the current datasource by clicking the update button. 4. After updating close the Set Datasource Location window. 5. Go to 'Database menu' and Click 'Verify Database' and click on ’OK’. 6. Preview the report and the save the report. Now, I did this plenty of times already before I posted this question here. The only thing I did not do is send the report back to my programmers and ask them to re-compile the application and send the DLL again. Woooff ... what a pain. Anyways, thanks for all the replies. I
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 this site About Us Learn
Error Failed To Open The Connection
more about Stack Overflow the company Business Learn more about hiring developers or posting failed to open the connection crystal report business objects ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community failed to open the connection. details database vendor code 4060 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 Crystal Reports “Failed to open the connection” error in ASP.NET http://forums.asp.net/t/997655.aspx?Crystal+Failed+to+open+Connection up vote 1 down vote favorite I have ASP.NET (C#) application which uses SAP Crystal Reports. In Visual Studio everything works well, but when I deploy it to IIS the following error occurs: "Failed to open the connection. Failed to open the connection 'report name'.rpt". I have changed my reports to use System DSN now the previous error gone but it generates following error: "Database Logon Failed" Any http://stackoverflow.com/questions/10635716/crystal-reports-failed-to-open-the-connection-error-in-asp-net suggestions? c# asp.net crystal-reports share|improve this question edited May 18 '12 at 8:06 asked May 17 '12 at 12:25 Adil Mammadov 4,48431139 Have you checked your connection properties? –5arx May 17 '12 at 12:31 Does the IIS account have the appropriate permissions? –ta.speot.is May 17 '12 at 12:32 Yes. Everything works in Visual Studio. I also have some other tables which pools data from same connection they also work well even when deployed –Adil Mammadov May 17 '12 at 12:34 @ta.speot.is I don't know what permissions should the user have. I am using NetworkService –Adil Mammadov May 17 '12 at 12:35 2 set user and password for connection –Meysam Savameri May 17 '12 at 13:34 | show 2 more comments 2 Answers 2 active oldest votes up vote 0 down vote Dim db As New _yourdbcontext() Dim cr As New ReportDocument cr.Load(Server.MapPath("~/yourreport.rpt")) cr.SetDataSource(db.yourtable.ToList()) CrystalReportViewer1.ReportSource = cr dont forget set user and password in crystal report and model connection share|improve this answer answered May 17 '12 at 20:11 Meysam Savameri 3531624 add a comment| up vote 0 down vote accepted If someone has this problem in Oracle please then check this link out. Hope i
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management https://www.experts-exchange.com/questions/28213447/Why-am-I-getting-this-Failed-to-open-the-connection-error.html for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury failed to and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and failed to open Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and Transpo
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Why am I getting this: "Failed to open the connection." error? Want to Advertise Here? Solved Why am I getting this: "Failed to open the connection." error? Posted on 2013-08-14 Crystal Reports MS SQL Server 2008 ASP.NET 1 Verified Solution 2 Comments 2,242 Views Last Modified: 2013-08-14 I have a web application written in ASP .NET 3.5 [C#]. i've created several crystal reports for this application that work. one how ever has consistently given me trouble. I've come to the conclusion (hopefully rightfully so) that it has to be the data within the table. Currently, in the report designer (through VS IDE), when i add the table (included as an excel spread sheet, with the 1st column's data blanked out for privacy reasons: they are names of real people), as long as i don't drag any fields onto the report designer its fine, its also, at that point, pointless because there is no data to display on the report. the moment i drag anything onto the report, save it and then browse to the page (locally or on the remote server) i get this error: Failed to open the connection. Details: [Database Vendor Code: 4060 ] Failed to open the connection. WkHstRpt {4C52DCE3-5261-4614-8FA7-4