OTN Discussion Forums : Crystal Reports 2008 doesn't show all ...

This question is not answered. Helpful answers available: 5. Correct answers available: 1.

Reply to this Thread

Search Forum

Back to Thread List

Replies: 7 - Pages: 1 - Last Post: Nov 9, 2009 4:45 PM Last Post By: user5721668

Threads: [ Previous | Next ]

user8096417

Posts: 20
Registered: 03/02/09

Crystal Reports 2008 doesn't show all schemas with ODBC
Posted: Oct 1, 2009 11:30 AM

I've got a developer using Crystal Reports 2008 to connect to our Oracle databases. Some are 9.2.0.4, the rest are 10.2.0.4. She created ODBC drivers on her Windows XP laptop but when she connects to the 10.2.0.4 databases she doesn't see all the schemas. If she connects using the Oracle Server method she see's all schemas. I've been trying to research this on the Crystal Reports side, but no luck.

Anyone here every see something like this? Where using the ODBC you connect to the database, but you only get some of the schemas?

Tks.

gdarling

Posts: 1,176
Registered: 01/10/01

Re: Crystal Reports 2008 doesn't show all schemas with ODBC
Posted: Oct 2, 2009 12:24 PM

in response to: user8096417

See if this helps,
http://www.sdn.sap.com/irj/scn/advancedsearch?query=1213798

Greg

user8096417

Posts: 20
Registered: 03/02/09

Re: Crystal Reports 2008 doesn't show all schemas with ODBC
Posted: Oct 5, 2009 5:55 AM

in response to: gdarling

Thanks but no. We have hundreds of tables at best, nowhere near the 8000 limit. Also, it's not tables that don't appear - it's the entire schema that's not there in the explorer view. Via the ODBC connection both user schemas and system schemas (SYSTEM in particular) just don't show up.

Justin Cave

Posts: 24,284
Registered: 10/11/99

Re: Crystal Reports 2008 doesn't show all schemas with ODBC
Posted: Oct 5, 2009 2:16 PM

in response to: user8096417

Do you know (and/or can you trace) the ODBC calls that Crystal Reports is making and/or the SQL statements the ODBC driver is issuing? My guess is that when Crystal is making the ODBC calls that it is passing arguments that tell the ODBC driver to ignore certain schemas. Since you would never create objects in the SYSTEM schema and very, very few people would have any reason to build Crystal Reports reports on top of objects delivered in the SYSTEM schema, my hunch is that Crystal excludes that schema explicitly when it makes the ODBC call. I don't know why it wouldn't do the same thing when you make a direct OCI connection-- potentially they never implemented that particular nicety when they had to directly query the data dictionary.

Justin

user8096417

Posts: 20
Registered: 03/02/09

Re: Crystal Reports 2008 doesn't show all schemas with ODBC
Posted: Oct 7, 2009 6:25 AM

in response to: Justin Cave

It's not just system schema. There is one database with 5 user schemas, only two of them show up using ODBC.

user12104352

Posts: 2
Registered: 10/23/09

Re: Crystal Reports 2008 doesn't show all schemas with ODBC
Posted: Oct 23, 2009 1:27 AM

in response to: user8096417

I experince the same issue and still can't figure out what happen
Looking forward to read another solution
Thanks

Justin Cave

Posts: 24,284
Registered: 10/11/99

Re: Crystal Reports 2008 doesn't show all schemas with ODBC
Posted: Oct 23, 2009 12:12 PM

in response to: user12104352

Do you know (and/or can you trace) the ODBC calls that Crystal Reports is making and/or the SQL statements the ODBC driver is issuing?

Justin

user5721668

Posts: 1
Registered: 11/09/09

Re: Crystal Reports 2008 doesn't show all schemas with ODBC
Posted: Nov 9, 2009 4:45 PM

in response to: user12104352

I'm seeing this as well. Any resolution?

Pages: 1

Back to Thread List

Threads: [ Previous | Next ]

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)