Symptom
- ODBC connection to DB2 database
- Errors selecting tables
- Error: ‘Database Connector Error (IBM)(CLI Driver)(DB2/6000) SQL10013N the specified library /opt/db2/sqllib/function/SYSIBM.SQLTABLES could not be loaded’
- Error: ‘Database Connector Error (IBM)(CLI Driver)(DB2/6000) SQL10013N the specified library /opt/db2/sqllib/function/SYSIBM.SQLPROCEDURES could not be loaded’
Reproducing the Issue
- From Crystal Reports, Database Expert, create new ODBC connection to DB2 database;
- Select tables;
Environment Information:
DB2 server: version DB2 v7.1.0.72
DB2 client: IBM DB2 Administration Client version 8.1.6
IBM ODBC Driver 8.01.06.664
Crystal reports 2008
Cause
The ODBC driver does not support the connection.
Resolution
- Use DataDirect ODBC driver 5.3 to connect to DB2 database
- The DataDirect driver 5.3 can be downloaded at http://service.sap.com/sap/bc/bsp/spn/bobj_download/main.htm with following values:
- Software product: Crystal Reports
- Product Version: 2008
- Software type: Utility
See Also
Further information on the DataDirect ODBC Driver 5.3 can be found at https://boc.sdn.sap.com/node/20035
Keywords
KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
Crystal Reports 2008 V0