ACC2: Microsoft Access and ORACLE ODBC Drivers

ID: Q112105


The information in this article applies to:


SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

Microsoft Access version 2.0 contains an ODBC driver for connecting to SQL Server. However, Microsoft Access 2.0 does not contain the ORACLE 6 or ORACLE 7 ODBC driver because customer research showed that relatively few people used the ORACLE driver that was shipped with Microsoft Access version 1.1.

If you have the ORACLE ODBC driver supplied with Microsoft Access version 1.1, however, you can use it with Microsoft Access version 2.0. The ORACLE ODBC driver included with Microsoft Access version 1.1 supports ORACLE 6 functionality and ORACLE 6 functionality in ORACLE 7, but does not support full ORACLE 7 functionality.

If you want full ORACLE 7 functionality, you can obtain the ORACLE 7 driver by purchasing the Microsoft ODBC Drivers Pack 2.0 Fulfillment Kit. This kit contains 32-bit ODBC drivers for Microsoft SQL Server 4.2 and 16-bit drivers for ORACLE 6 and ORACLE 7.

You can call Microsoft Sales at (800) 426-9400 (or (425) 882-8080 from outside the United States) to order the Microsoft ODBC Drivers Pack 2.0 (part number 273-054-0300). The price is $10.25 (to cover the cost of materials and shipping) for any customer who owns one of the following Microsoft products:

Additional query words: importing exporting attaching


Keywords          : kbinterop OdbcOracl 
Version           : 2.0
Platform          : WINDOWS 
Issue type        : kbinfo 

Last Reviewed: April 2, 1999