Thursday, November 10, 2011

Fix: Crystal Reports 2008 Database Explorer Doesn't Show All Schemas [Field Notes]

Issue
In Crystal Reports 2008, I am attempting to add a ODBC datasource (connecting to an Oracle 11g database) so that I can change field links, etc.

However, when I go into the Database Explorer and create an ODBC connection, certain system and user schemas show up, but mine is not in the list, despite the fact that I can view and query that schema/user in many other Oracle clients such as SQL Developer or DBVisualizer.

Resolution
This seems to be a strange bug. According to this helpful (but obscure) forum post, the way to resolve the issue is to:

  • On the menu bar, select File --> Options.
  • Click the "Database" tab.
  • Uncheck the "Stored Procedures" option.
I have no idea why this fixes the issue, but it certainly did. Very happy to have this one behind me.

No comments:

Post a Comment

Keep it classy, folks.