Crystal Report Cannot Obtain Error Message From Server
Contents |
Previous post Next post Currently Being Moderated Database connector error in Crystal Report when accessing stored procedure Posted by Veni Kosana in SAP Crystal Reports on Aug 10, 2012 9:02:02 PM Tweet I have created a stored procedure in MS SQL Server 2005 with database connector error crystal reports one input parameter and three output parameters. I have executed the query successfully crystal reports database connector error failed to retrieve data from the database in SQL Server. Now I am trying to built a report using this stored procedure. When I select the stored procedure crystal reports unknown database connector error in Crystal Reports database expert it prompts for the input and output parameters. When I enter them and press OK then I get the following error.Database Connector Error:'Cannot obtain error message from server.'My first
Database Connector Error If Tables Are Already Linked Then
question is how should I pass the output parameter, I have declared the output parameters as VARCHAR(10) in stored procedure in SQL server.So, do I have to pass it as for eg. @rate OR {?rate} OR rate.I don't think I have any problems with ODBC drivers or Grants. If I create a stored procedure with on output paratmeters, I have no issues. I am able to add it to unknown database connector error crystal reports 2008 the datasource and get the data in the report.I feel I am having issue only with the output parameters. Did I miss anything? Can anyone please help me.Thanks 8429Views Tweet Comments 12 Comments Name (Required) Email Address (Required, will not be published) Website Address Name (Required) Email Address (Required, will not be published) Website Address <%= commentBody %> Actions Login to follow, like, comment, share and bookmark content. Login Register Filter Blog By author: --- Dell Stinnett-Christy Aaron Cope Abhisek Das abuthaheer abdul Malik Ahmed Alaa Kharma A Mu Andrew Baines Arun Gouru Arya Arya Ashish Dwivedi Ashok kumar M Basavaraj Guttedar Benjamin Witt Blair Wheadon Carlos Gonzalez Carmen Hoskins Chris Jones Connor Woods Cristina Colonisteanu Danish Ahmad Daniel Castro Darl Chang Dave Nash David Banjo David McAmis David Shipmon Dennis Byram Debapriya Mandal Derek Chassay Dharmesh Shah Dinesh r Eric Korslin Éric Ledu Esha Abdullah Ganesh Bothe gary hazzard Geeta Bagga George Divens Gevorg Meliksetyan Hari krishna Addepalli Hessel de Walle hu po ingela lofstedt jaheer ussain babu shajakhan James Oswald Jamie Wiseman Jason Cao jay mintas Jeff Mowrey Jennifer Petrik Jeroen van der A jerry Martinez Joan Lu John Strauss John Sun Jon Hanshew Julie Caton Justin VP Karthik R Kathy Kel
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 more about Stack Overflow the company Business Learn more about hiring developers or posting ads database vendor code 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 crystal report showing error --> Database connector error: 'Cannot obtain error message from server' up vote 3 down vote favorite I am trying to work on a already existing crystal report file. It has given to me by someone else. http://scn.sap.com/community/crystal-reports/blog/2012/08/10/database-connector-error-in-crystal-report-when-accessing-stored-procedure It has two table in its 'Database fields'. When i try to run it in my system it runs properly. But i need to edit this report and add some new columns in it so when i have added 1 more table to Database field and uses some data from that newly added table in my crystal report it gives This error "Database connector error: 'Cannot obtain error message from server". Please can somebody tell me how to remove this error? crystal-reports share|improve http://stackoverflow.com/questions/25114074/crystal-report-showing-error-database-connector-error-cannot-obtain-error this question edited Aug 4 '14 at 8:01 Siva 5,99952140 asked Aug 4 '14 at 7:59 user3732694 557 Did you add the table from an existing data source, or did you add a new data source? –Jim Lutz Jul 20 at 13:03 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Have you try to verify database option of Table.if not then in database field click the verify database on your table properties it will work. share|improve this answer answered Aug 4 '14 at 8:34 nilima 12 yes i have tried it says database up todate –user3732694 Aug 4 '14 at 9:16 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged crystal-reports or ask your own question. asked 2 years ago viewed 2292 times active 2 years ago Related 1“No free license” error in Crystal Reports0running a script from within crystal reports0Error regarding crystal report?0crystal report error1Unknown Database Connector Error in Crystal Reports0Crystal Report Show Database query0Crystal reports cannot show data0How to show image/word document/pdf in crystal report0Cannot find cause for Crystal Reports error “One or more fields cannot be found
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 https://www.experts-exchange.com/questions/28072625/Crystal-Reports-cannot-obtain-error-message-from-server-temp-table-and-stored-procedures.html for a Full Time Job Ways to Get Help Expand Search Submit Close http://www.forumtopics.com/busobj/viewtopic.php?p=904131 Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Crystal Reports - cannot obtain error message from server - temp table and stored procedures Want to Advertise Here? Solved Crystal Reports - cannot obtain error message from server - crystal report temp table and stored procedures Posted on 2013-03-21 MS SQL Server Crystal Reports 1 Verified Solution 2 Comments 1,143 Views Last Modified: 2013-03-21 Hi. I created a crystal report (9.0) and attached it to a sql server 2000 stored procedure (below). The sp does the following: - creates temp table (declare @tmp table) - inserts records from receiving table - inserts records from database connector error 3 or 4 other tables - final select from @tmp It's pretty basic. If the first insert has no records, I get an error when running Crystal from our Protean ERP system. It works if I run the report directly from Crystal and the stored procedures runs fine when I run it outside of Crystal. - If first insert has records, it runs fine even if following inserts don't have data - If I insert a blank record before doing the other inserts, then it runs fine. I'd hate to have to use this fix because I have hundreds of reports. It's only an issue if the first insert has no records. Stored procedure is below. Thanks! --/* ALTER PROCEDURE a_cstScansRescJulianAnalysis @Resc varchar(35), @Lot varchar(10) AS --*/ /* test variables DECLARE @Resc varchar(35) DECLARE @lot varchar(10) SET @Resc='03308' SET @Lot='3079' */ DECLARE @tmp TABLE ( BatchNum varchar(30), ResourceUK varchar(35), AlQty float(8), PrQty float(8), Lot varchar(10), Serial varchar(5), ScanDateTime datetime, ScanDateTimeText varchar(30), ShipOffice varchar(15), String varchar(120), StationID varchar(2), Status var
+ Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23. Database connector error in Crystal Reports storedprocedure Search this topic...|Search Crystal Reports...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered Posts Register or Login to Post Forum Index -> Building Reports -> Crystal Reports Author Message KVKForum MemberJoined: 17 Apr 2012Posts: 10 Posted: Fri Aug 10, 2012 2:09 pmPost subject: Database connector error in Crystal Reports storedprocedure I have created a stored procedure in MS SQL Server 2005 with one input parameter and three output parameters. I have executed the query successfully in SQL Server. Now I am trying to built a report using this stored procedure. When I select the stored procedure in Crystal Reports database expert it prompts for the input and output parameters. When I enter them and press OK then I get the following error. Database Connector Error: 'Cannot obtain error message from server.' My first question is how should I pass the output parameter, I have declared the output parameters as VARCHAR(10) in stored procedure in SQL server. So, do I have to pass it as for eg. @rate OR {?rate} OR rate. I don't think I have any problems with ODBC drivers or Grants. If I create a stored procedure with on output paratmeters, I have no issues. I am able to add it to the datasource and get the data in the report. I feel I am having issue only with the output parameters. Did I miss anything? Can anyone please help me. ThanksLast edited by KVK on Wed Aug 15, 2012 2:24 pm, edited 1 time in total Back to top KirtiKaleForum MemberJoined: 13 Aug 2012Posts: 1Location: Pune Posted: Mon Aug 13, 2012 3:42 amPost subject: Re: Database connector error in Crystal Reports storedproce Hello, Have you compiled and executed stored procedure successfully at the backend? If not, then please do it first then Log off and then log on your specified data source connection from Database(menu)>Log On or Off server... option. Back to top sudarsan29Forum MemberJoined: 03 Aug 2012Posts: 9 Posted: Mon Aug 13,