This content has been marked as final. Show 11 replies
See if this helps,
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.
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.
It's not just system schema. There is one database with 5 user schemas, only two of them show up using ODBC.
I experince the same issue and still can't figure out what happen
Looking forward to read another solution
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?
I'm seeing this as well. Any resolution?
I am experiencing the same issue.
Not ideal, but I found a work arround:
Create a custom Command for every table you need. Simply add 'Select * from SchemaName.tablename' to the Custom Command and save it as the tablename.
I hope someone has a better solution as it saves quite some time.
we had a users that was missing some schemas... this was our fix.
Crystal Reports --> Menu --> File --> Options… --> Database [tab]
- uncheck Stored Procedures checkbox
Thanks doug, unchecking Stored Procedures checkbox solved the problem on our side.
I had this same problem and this was the answer. Thank you very much.