Home > Crystal Report > Crystal Reports Database Connector Error Cannot Obtain Error Message From Server

Crystal Reports Database Connector Error Cannot Obtain Error Message From Server

Contents

If you get an error, then this is indeed your problem. Alternatively, may be the user does not have permissions to delete from this table. Zack Hasanov June 05, 2009 at 23:29 PM 0 Likes Helpful Answer by Guest Zilla Eh 7 replies Share & Follow Privacy Terms of Use Legal Disclosure Copyright Trademark Sitemap Newsletter Now i have added 3 more parameter to the above SP. http://outwardsound.com/crystal-report/how-to-connect-crystal-reports-to-sql-server-database.html

MS SQL Server Advertise Here 791 members asked questions and received personalized solutions in the past 7 days. Browse other questions tagged crystal-reports or ask your own question. Did you try the same DELETE code running standalone? What I observed was once I am trying to get the output value I am getting the Database error.

Crystal Reports Database Connector Error Cannot Obtain Error Message From Server

Resolution Workaround: Instead of using Microsoft ODBC driver for Oracle, use DataDirect Oracle ODBC driver (DataDirect 5.3 Oracle) to connect to Oracle 11g Server.I hope this helps.I was looking for something I have found that in those situations, it is essential to get hold of the original error message. Details: Cannot obtain error message from server." I tried to make new connection with this stored procedure, but stil didn't work. Signup for Free!

Register Hereor login if you are already a member E-mail User Name Password Forgot Password? Thanks. The sp does the following: - creates temp table (declare @tmp table) - inserts records from receiving table - inserts records from 3 or 4 other tables - final select from Database Vendor Code I can select a table, but there's an error when I try to set a stored procedure as data source.

Reply With Quote Quick Navigation Crystal Reports Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Visual C++ & C++ Programming Visual C++ Programming Visual C++ Sunday, November 20, 2011 2:40 AM Reply | Quote 0 Sign in to vote I discovered the error did not occur when I removed the code to delete data from the 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 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

I got the same error. Below in REPLACE WITH --> CREATE NEW CONNECTION -->ODBC(RDO)--> MAKE NEW CONNECTION--> WITH THE RESPECTIVE DATABASE , I selected the SP and in the right side i CLICK on UPDATE button Yeh, i did mean deleting rows, not the table. i got this error for this crystal report , before i have done for the other 2 reports , its working fine....

Crystal Reports Database Connector Error Failed To Retrieve Data From The Database

We'll email youwhen relevant content isadded and updated. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Crystal Reports Database Connector Error Cannot Obtain Error Message From Server Suggested Solutions Title # Comments Views Activity monitor queries that use too much tempdb log 20 27 13d ODBC--call failed error Access 2016/SQL 6 21 18d How can I retrieve accounts Database Connector Error If Tables Are Already Linked Then The Join Type Cannot Change Join & Ask a Question Need Help in Real-Time?

Now I am trying to built a report using this stored procedure. http://outwardsound.com/crystal-report/crystal-reports-2008-download.html All due to a catastroph… Concerto Cloud Services Dealing With Dates: Manipulating Dates (SQL Server) Video by: Steve Using examples as well as descriptions, and references to Books Online, show the I tried several scenarios, I can create the report using a Stored Procedure with parameters provided that these parameters are assigned a value inside the Stored Proc, or if these parameters Please enter a reply. Unknown Database Connector Error Crystal Reports 2008

I able to use the stored procedure without references to the table, so I think I'll just go that route. First You are Deleteing your Table 'EquipPartDesc' in your code. To start viewing messages, select the forum that you want to visit from the selection below. this contact form Thanks!

It has given to me by someone else. There are some logical issues which you might need to look into. Following Follow Database Connection Error When I opened a crystal report from design mode to Preview mode It thrown this error:’’Database Connection Error:’Cannot obtain Error message from server’ and, ODBC Error(Merant)

We'll email you when relevant content is added and updated.

Join Now For immediate help use Live now! SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[get_measures_with_output_para] (@meas_system_seqno Numeric() AS BEGIN SET NOCOUNT ON; DECLARE @inlet_rate VARCHAR(10) DECLARE @inlet_size VARCHAR(10) DECLARE @inlet_temp VARCHAR(10) select @inlet_rate = syum.unit_of_measure_label Register Hereor login if you are already a member E-mail User Name Password Forgot Password? Anyone have any suggestions?

Privacy Reply Processing your reply... We'll let you know when a new response is added. Results 1 to 2 of 2 Thread: Cannot create Crystal Report using a Stored Procedure with parameters Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced http://outwardsound.com/crystal-report/crystal-reports-pdf-export-problem.html Since it will Delete the rows and you won't be getting any rows.

See if the same error exists. IP Logged KENNY Newbie Joined: 14 Dec 2011 Location: Ghana Online Status: Offline Posts: 2 Posted: 20 Dec 2011 at 10:42pm Thank for your support and suggested solution. We'll email youwhen relevant content isadded and updated. There has already been a few people who have pointed out problems to your stored procedure, but I would like to give some attention to the error message from Crystal.

Register Hereor login if you are already a member E-mail User Name Password Forgot Password? I'd hate to have to use this fix because I have hundreds of reports. 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| Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Say, some of the records have child records in other tables and the foreign key constraint prevents deletion of such records, but CR can not property report the error. Register Hereor login if you are already a member E-mail User Name Password Forgot Password? Best brain IP Logged PLMJAN Newbie Joined: 19 Dec 2011 Location: New Zealand Online Status: Offline Posts: 1 Posted: 19 Dec 2011 at 10:25am Have you checked File / Options/ MS SQL Server MS SQL Server 2005 MS SQL Server 2008 5 Lessons the Delta Outage Should Teach Us About Datacenter Security and Disaster Prevention Article by: Concerto Cloud The Delta

Privacy Follow Thanks! I feel I am having issue only with the output parameters. When i try to run it in my system it runs properly. What do I do with my leftover cash?

Please try again later. say 5 parameters and i have been using this SP in crystal report. You may have to register or Login before you can post: click the register link above to proceed. Skip to Content Open navigation Account Settings Notifications Followed Activities Logout Search Your browser does not support JavaScript.

If I create a stored procedure with on output paratmeters, I have no issues. limit.) Question: (Please be specific.) Tags: (Separate with commas.) What is a Tag? Get 1:1 Help Now Advertise Here Enjoyed your answer?