Skip to Content
Former Member
Jul 02, 2007 at 08:26 PM

Odd ODBC issue with DB2


Post Author: Nicholas

CA Forum: Data Connectivity and SQL

We have a group of 100 or so reports that are being reviewed due to a massive upgrade made to a database. These reports were created in Crystal 8-ish all the way up to XI.We had someone change the DB2 library in an ODBC connection to the new library so they could open the reports, run them, and keep a list of which one's need to be updated. The problem we just ran in to, is that some of the reports are still pulling from the old library. When you click "Show SQL Query" it has the old library listed in the SQL.From what I've seen, the reports with parameters seem to show the old library, those without parameters are showing the correct library that the ODBC connection was changed to.The only way I've been able to get the report to pull from the correct library was to manually update the tables. Updating at the database level didn't work.Has anyone run into an issue like this?The plan was to change the ODBC settings so the reports would pull from the new database. If we have to manually update each table in each report, this will take 10 times longer to do.Any suggestions would be appreciated.