Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Crystal - Oracle 10g - Where are my tables? Post Reply Post New Topic
Author Message
AntDC
Groupie
Groupie
Avatar

Joined: 23 Dec 2008
Online Status: Offline
Posts: 76
Quote AntDC Replybullet Topic: Crystal - Oracle 10g - Where are my tables?
    Posted: 23 Jan 2009 at 1:31am
Hi all,
we develop reports against schema A.
QA tests on schema B.

When QA finds problems I need to also verify against B.

This is where it gets crazy....
I can create a new report against a table in B and all is well.
However, if I open up the report created against schema A and change the login credentials to point at schema B, I cannot preview.  Crystal tells me the tables do not exist and then finishes with an ORA 01031 0 Insufficient privileges error.

WTH - I can create a new one looking at those same table on schema B.
I can also run SQL against the tables in B via SQL developer.

I'm obviously missing something here - but what it is I can tell.

Please help before some poor soul outside gets killed by a lapttop hitting him on the head.

Regards

DC


Edited by AntDC - 23 Jan 2009 at 1:31am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 25 Jan 2009 at 7:48pm
Crystal accesses Oracle tables with the format schema_owner.table_name.  Just changing the login doesn't update the schema owner.  Instead you need to go to the database menu and choose "set location", create a connection to the QA schema, and link the tables from the dev schema to the corresponding tables in the QA schema.
 
-Dell
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.016 seconds.