ODBC Driver for v8.15

From: <bethc_at_my-deja.com>
Date: 2000/08/11
Message-ID: <8n1jqu$2jr$1@nnrp1.deja.com>#1/1

I just had a customer upgrade his Oracle database to v8.15. I don't know exactly what version he ran previously, but I know it was at least version 8.0. Some of the ADO code in my VB6 app now causes ODBC errors.
The following code:
Recordset.open "tablename", connection

gives me an "Invalid SQL statement" error

a where clause:
where table1.field1 = table2.field2

gives me an "Error occurred at recursive SQL level 1" and an "Invalid column name" error. If I delete the where clause, the SQL runs fine despite the fact that table1.field1 and table2.field2 are in the select statement.

I've been using MS ODBC for Oracle 2.573.4403.00, but I've also tested Oracle ODBC 8.0.03.00.

I downloaded Oracle ODBC 8.16 but discovered that I had to have Universal Installer to install it.

Any insights greatly appreciated.

Thanks,
Beth

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Aug 11 2000 - 00:00:00 CDT