Cannot Obtain Error Message From Server
Contents |
SAP Crystal ReportsWhere is this place located?All Places SAP Crystal Reports 7 Replies Latest reply: Aug 7, 2009 6:13 PM by Zack Hasanov Tweet Database Connection Error: Cannot obtain error message from the server Zack Hasanov Jun 5, 2009 11:29 PM Currently Being Moderated I have crystal reports cannot obtain message from server a SQL statement that wants to add a temp table to the database. The SQL
Crystal Report Error Database Connector
statement works fine but when I try to add it via 'Add Command' feature in Crystal XI R2, I get the following crystal reports database connector error failed to retrieve data from the database error message:Database Connection Error: Cannot obtain error message from the serverAny ideas?Thanks in advance,Zack H. 4399Views Re: Database Connection Error: Cannot obtain error message from the server Guest Jun 5, 2009 11:49 PM (in response to Zack
Crystal Reports Unknown Database Connector Error
Hasanov) Currently Being Moderated Can you try creating a stored procedure with the query and adding this to the report? also can you paste the query here?Regards,RaghavendraEdited by: Raghavendra Gadhamsetty on Jun 5, 2009 11:49 PM Like (0) Re: Database Connection Error: Cannot obtain error message from the server Zack Hasanov Jun 22, 2009 5:09 PM (in response to Guest ) Currently Being Moderated Hi Raghavendra,I am using this in the 'Add Command' feature but database connector error if tables are already linked then I get the error message displayed in the subject line: CREATE TABLE #TibetanYaks( YakID char(4), YakName char(20) ) INSERT INTO #TibetanYaks (YakID, YakName) SELECT LastName, FirstName FROM Employee WHERE EmployeeID between '2000' and '3000'I haven't tried to add this as a stored procedure but I imagine it will work as I have no problems yet with stored procedures. I simply want to be able to use temporary tables for the sole purpose of that session and not creating anything static in the database.By the way, even though I get the error message, when I look on the backend database, I see that the temporary table was successfully created...its just not brought across correctly in Crystal.Any ideas?Zack H. Alert Moderator Like (0) Re: Database Connection Error: Cannot obtain error message from the server Zack Hasanov Jun 23, 2009 10:22 PM (in response to Zack Hasanov) Currently Being Moderated Just following up on this thread.Any ideas how to successfully bring a temp table to the database expert?Regards,Zack H Alert Moderator Like (0) Re: Database Connection Error: Cannot obtain error message from the server Zack Hasanov Jun 30, 2009 5:10 PM (in response to Zack Hasanov) Currently Being Moderated Any updates on this thread? Alert Moderator Like (0) Re: Database Connection Error: Cannot obtain error message from the server Zilla Eh Jun 30, 20
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search
Unknown Database Connector Error Crystal Reports 2008
related threads Remove From My Forums Answered by: crystal
Database Vendor Code
reports stored procedure error SQL Server > Transact-SQL Question 0 Sign in to vote I have created a stored procedure that updates an existing table with the values in the CTE. I want to use https://scn.sap.com/thread/1367730 this stored procedure as the datasource for my Crystal Report, but when I select it, I get the following error: Data Connection Error: "Cannot Obtain Error Message From Server". Code of stored procedure is below. Anyone have any suggestions? Thanks! USE https://social.msdn.microsoft.com/Forums/sqlserver/en-US/35a4e984-240c-4257-9c00-a9e8d7f5d30d/crystal-reports-stored-procedure-error?forum=transactsql [AdventureWorks] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO --IF OBJECT_ID ( 'ParseEquipCustom', 'P' ) IS NOT NULL -- DROP PROCEDURE ParseEquipCustom; --GO ALTER PROCEDURE ParseEquipCustom AS SET NOCOUNT ON; Delete from EquipPartDesc; WITH [Parse_cte] ([CustNo], [LocNo], [EquipCount], [Serial], [Schedule], [EquipPart], [EquipPartDesc], [Qty]) -- CTE name and columns AS ( select e.CustNo, e.LocNo, e.counter, e.Serial, e.custom7, 'equipPart' = CASE WHEN CHARINDEX(';', e.Custom1) > 0 Then SUBSTRING(e.custom1,(CharIndex('-', e.Custom1)+1), (CHARINDEX(';', Custom1)-CharIndex('-', e.Custom1))-1) --VALUE_EXPRESSION, START, LENGTH WHEN CHARINDEX('-', e.custom1)=0 Then e.custom1 ELSE SUBSTRING(e.custom1, 3,len(e.custom1)) END, 'EquipPartDesc' = 'Belt', 'Qty' = CASE WHEN CHARINDEX('-', e.custom1)>0 Then SUBSTRING(e.custom1, 1, (Charindex('-', e.custom1))-1) Else 0 End From Equip e Union All --Custom1 Two Belts, Gets second belt select e.CustNo, e.LocNo, e.counter as EquipCount, e.Serial, e.custom7 as Schedule, 'equipPart' =SUBSTRING(e.custom1, (CharIndex('-', e.Custom1, (Charindex(';', Custom1)))+1), LEN(e.custom1)), 'EquipPartDesc'
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 https://www.experts-exchange.com/questions/28072625/Crystal-Reports-cannot-obtain-error-message-from-server-temp-table-and-stored-procedures.html 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 > 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 - temp table and stored procedures Posted on 2013-03-21 MS SQL Server Crystal Reports crystal report 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 3 or 4 other tables - final select from @tmp It's pretty basic. If the first insert has no database connector error 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 varchar(15), ScanUser varchar(20), ScanType varchar(30) ) --INSERT @tmp (BatchNum) values('') -------------- Insert receiving scans INSERT @tmp (BatchNum, ResourceUK, AlQty, PrQty, Lot, Serial, ScanDateTime, ShipOffice, String, StationID,Status, ScanUser, ScanType) select OrderName, ResourceUK, A