DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle 9 ODBC Driver not work

223149Oct 25 2002

Hi,

Does anyone have problem in using Oracle 9i ODBC driver?

My application supports Oracle 8i (DB + Oracle ODBC driver) very well with ODBC API and ADO, no any problem. I am testing it in Oracle 9i. The environment is: windows 2000 + Oracle 9i(9.2.0.1.0) DB + Oracle 9i ODBC driver.
I have two versions of ODBC drivers: 9.02.00.00 (dated on 3/12/2002)and 9.02.00.02 (dated on 6/20/2002). With the earlier version, it seems I have no problems in ODBC API, but problem in ADO. "select distinct ...." does not work in ADO, the first column fetched missing. With the latter version, ADO works, but ODBC API does not work stable in transaction control, if only fetch something, it seems OK, but no stable within a transaction for changing data in DB.

There are some special considerations in configuaration for Oracle 9i. Is Oracle 9 ODBC driver certified in Windows.

Thanks for your suggestion.

Hongliang Wang

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 22 2002

Added on Oct 25 2002

#odbc, #windows-and-net

5 comments

584 views