A report that ran in 6i using OCA/ODBC, no longer works in Oracle 10g.
Oracle Reports 10g uses JDBC. ODBC was upgraded to the new industry standard, JDBC. To determine why the report no longer runs:
Determine if the datasource is ODBC or JDBC compliant.
If it is ODBC but not JDBC compliant, make sure the JDBC-ODBC bridge is installed. The bridge may be downloaded from Sun Microsystems.
If you are unable to resolve the error, call Oracle Support Services.
Accessing non-Oracle data sources
Adding a pluggable data source
Connecting to a pluggable data source
Adding online Help to a pluggable data source
Pluggable data source interface definition
Copyright © 1984, 2005, Oracle. All rights reserved.