Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Not supported. Details: Cannot obtain error messag Post Reply Post New Topic
Author Message
Dado-Crystal
Newbie
Newbie


Joined: 19 Feb 2008
Location: Slovenia
Online Status: Offline
Posts: 1
Quote Dado-Crystal Replybullet Topic: Not supported. Details: Cannot obtain error messag
    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 Oracle database (client 10g).

Thank you for any suggestions.

Dado

Edited by Dado-Crystal - 19 Feb 2008 at 1:04am
IP IP Logged
nseaeast
Newbie
Newbie


Joined: 07 Apr 2011
Location: Vietnam
Online Status: Offline
Posts: 3
Quote nseaeast Replybullet Posted: 07 Apr 2011 at 5:56am
I have the same problem, anybody help.
IP IP Logged
CircleD
Senior Member
Senior Member
Avatar

Joined: 11 Mar 2011
Location: United States
Online Status: Offline
Posts: 251
Quote CircleD Replybullet 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.
IP IP Logged
KENNY
Newbie
Newbie
Avatar

Joined: 14 Dec 2011
Location: Ghana
Online Status: Offline
Posts: 2
Quote KENNY Replybullet Posted: 15 Dec 2011 at 1:22am
i have the same problem the only difference is that am using SQL stored procedure.
Best brain
IP IP Logged
PLMJAN
Newbie
Newbie
Avatar

Joined: 19 Dec 2011
Location: New Zealand
Online Status: Offline
Posts: 1
Quote PLMJAN Replybullet 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.
IP IP Logged
KENNY
Newbie
Newbie
Avatar

Joined: 14 Dec 2011
Location: Ghana
Online Status: Offline
Posts: 2
Quote KENNY Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.