Re: Oracle, ODBC, and MS Access 2.0

Cheers Tim.

I downloaded the Oracle7 ODBC Driver for Windows, and installed them. I can connect fine using the ODBC Test software which comes as part of the installation, which proves that my SQLNet is working fine. But when I try to attach a table (or open an attached table) in a MS Access 2.0 database I get a 7551 conformance error message.

After checking the help file, the Installing ODBC bulletin on Oracle's website, and checking my configuration files, the ODBC installation routine has setup links to SQORA73.DLL. The bulletin shows examples for SQORA71.DLL. Have I downloaded the wrong driver, or have I missed something?

Tim Greenleaf wrote:

> Allan sounds like he knows what he is talking about but we never got the
> 32-bit drivers to work with 16 bit applications and I believe somewhere on
> Oracle's site they even say that thier 32 bit drivers will not work with 16
> bit apps. We have had 16 bit and 32 bit ODBC driver co-exsisting on Windows
> 95 and NT 4 for the past couple of years with no problems.
>
> You can get the 16 bit drivers for free on Oracle site in the free donwload
> area.
>
> Tim
Received on Wed Feb 24 1999 - 05:58:32 CST