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.
This seems to be a strange bug. According to this helpful (but obscure) forum post (Ed. Note: unfortunately, the link has been lost to time), the way to resolve the issue is to:
- On the menu bar, select
File > Options
- Click the
- Uncheck the
I have no idea why this fixes the issue, but it certainly did. Very happy to have this one behind me.