Print Page | Close Window

Not supported. Details: Cannot obtain error messag

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2365
Printed Date: 30 Apr 2024 at 1:14pm


Topic: Not supported. Details: Cannot obtain error messag
Posted By: Dado-Crystal
Subject: Not supported. Details: Cannot obtain error messag
Date Posted: 19 Feb 2008 at 12:53am
Hello everybody,
i'm new at working with crystal report 9.2 and i'm having some problems.
Problem is, that I can't select stored procedure as data source in Crystal report. I can select a table, but there's an error when I try to set a stored procedure as data source.
Thing is, that I have to make some changes on an existing report and when I try to verify database (I made some changes in stored procedure) I get this message: "Not supported. Details: Cannot obtain error message from server." I tried to make new connection with this stored procedure, but stil didn't work. I got the same error.
I also have to tell, that this procedure works fine, when I start it from VB, but in Crystal report it doesn't work, and that this procedure is a part of package in javascript:void%280%29 - Oracle database (client 10g).

Thank you for any suggestions.

Dado


Replies:
Posted By: nseaeast
Date Posted: 07 Apr 2011 at 5:56am
I have the same problem, anybody help.

Posted By: CircleD
Date Posted: 12 Apr 2011 at 5:28pm
From SAP's Knowledge base Article:

Symptom

  • Schema tables(e.g scott.emp) do not appear in the Database Expert window

Environment

  • Crystal Reports 2008
  • Oracle 11g Database Server
  • Microsoft ODBC for Oracle(MSORCL32.DLL Version 2.576.3959.00)
  • Oracle in OraClient10g_home1(SQORA32.DLL Version 10.02.00.01)

Reproducing the Issue

  1. Create a new ODBC data source using Microsoft ODBC for Oracle.
  2. Launch Crystal Reports 2008.
  3. Click File > New > Blank Report.
  4. Expand Create New Connection in the Available Data Sources.
  5. Expand ODBC (RDO).
  6. Select ODBC Data Source name in the ODC (RDO) window and click Finish.
  7. Type User ID and Password when prompting connection information window and click Finish.
  8. There are no schema tables listing in the Available Data Sources.

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 else and spotted this.




-------------

Posted By: KENNY
Date Posted: 15 Dec 2011 at 1:22am
i have the same problem the only difference is that am using SQL stored procedure.



-------------
Best brain

Posted By: PLMJAN
Date Posted: 19 Dec 2011 at 10:25am
Have you checked File / Options/ Database tab?
Under Data Explorer, Stored Procedures needs to be ticked.

Also, try logging in to (for example) SQL Server Management Console, for SQL as the user you are using for CR, and make sure that user has permisssions granted to the Stored Procedure.

Hope this helps.

Posted By: KENNY
Date Posted: 20 Dec 2011 at 10:42pm
Thank for your support and suggested solution. But i must say that i have done all that.

-------------
Best brain


Print Page | Close Window