Incompatibility with Oracle 8.1.6 db and Oracle 8.1.7 ODBC driver?
I'm attempting to connect to an Oracle 8.1.6 database using vb6 adodb and an Oracle 8.1.7 ODBC driver. I'm able to successfully connect to the database, but when I attempt to open a table, the program hangs.
In looking at the log file from running a trace, the last line it shows is the following...
VB6 118-46 ENTER SQLExecDirectW
HSTMT 031C2000
WCHAR * 0x030CDF50 [ 25] "select * from BARTRESULTS"
SDWORD 25
where "BARTRESULTS" is the table name.
I read a thread on incompatibilities between Oracle 8.1.6 and 8.1.7, so is this one of the incompatibility issues? If so, is there a way to uninstall my 8.1.7 ODBC driver, and install a 8.1.6 ODBC driver? I attempted to do this using the Oracle Universal Installer, but it didn't seem to work.
Your help is greatly appreciated. Thanks.