Crystal - Oracle 10g - Where are my tables?
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=5309
Printed Date: 15 May 2024 at 10:24pm
Topic: Crystal - Oracle 10g - Where are my tables?
Posted By: AntDC
Subject: Crystal - Oracle 10g - Where are my tables?
Date 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
|
Replies:
Posted By: hilfy
Date 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
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|