ACC: Which ODBC Driver Do I Use and Where Do I Get It?

Last reviewed: February 4, 1998
Article ID: Q147192

The information in this article applies to:

Microsoft Access versions 2.0, 7.0, 97

SUMMARY

Moderate: Requires basic macro, coding, and interoperability skills.

This article lists Microsoft SQL Server and ORACLE ODBC drivers which you can use with various versions of Microsoft Access and Microsoft Windows. In addition, the article lists the sources from which you can obtain the ODBC drivers.

MORE INFORMATION

Microsoft SQL Server

 MS Access   Client Operating   SQL Server     Sources of ODBC
  Version        System          Version           Driver
 --------------------------------------------------------------------------

   2.0       Windows 3.1          4.21a       MS Access 2.0 Upsizing Tools
             WFW 3.1                          16-bit ODBC 2.5 Drivers
             Windows 95                       for the Win16 Client from
                                              the clients folder on the
                                              Microsoft SQL Server CD.

   2.0       Windows NT 3.51      4.21a       16 bit drivers (above) or
                                              32 bit ODBC driver from
                                              the ODBC folder on the
                                              Microsoft SQL Server CD.

   2.0       Windows 3.1          6.x         16-bit ODBC 2.5 Drivers
             WFW 3.1                          for the Win16 Client from
             Windows 95                       the clients folder on the
                                              Microsoft SQL Server CD.

   7.0       Windows 95           4.21a/6.x   Microsoft Access 7.0
             Windows NT 3.51/4.x              ODBC Drivers Appnote from
                                              the clients folder on the
                                              Microsoft SQL Server CD

   97        Windows 95           4.21a/6.x   Microsoft Access 7.0
             Windows NT 3.51/4.x              ODBC Drivers Appnote
                                              the clients folder on the
                                              Microsoft SQL Server CD

ORACLE

 MS Access   Client Operating   ORACLE         Sources of ODBC
  Version        System         Version            Driver
 --------------------------------------------------------------------------

    2.0      Windows 3.1         6.0 with      Microsoft Access 1.1
             WFW 3.1             SQL*Net 1.x   MS ODBC Drivers Pack 2.0
             Windows 95                        ODBC Fulfillment Kit
             Windows NT 3.51

    2.0      Windows 3.1         7.0           ODBC Fulfillment Kit
             WFW 3.1             SQL Net 1.x
             Windows 95
             Windows NT 3.51

    2.0      Windows 3.1         7.0 with      ODBC Fulfillment Kit
             WFW 3.1             SQL Net 2.x
             Windows 95
             Windows NT 3.51

    7.0      Windows 95          6.0/7.x       Microsoft ODBC Drivers.
             Windows NT 3.51/4.x               Appnote available on MSL.

    97       Windows 95          6.0/7.x       Driver not available.
             Windows NT 3.51/4.x

For information on obtaining the Microsoft ODBC Drivers Appnote, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q149961
   TITLE     : ACC: Microsoft ODBC Drivers Available on MSL

For information on using the Visigenic 32-bit ODBC driver for ORACLE 7, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q140498
   TITLE     : INF: Using the Visigenic ORACLE Driver on WinNT & Win95

REFERENCES

For more information about the ODBC Drivers Appnote, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q139487
   TITLE     : WX1220: ODBC 32-Bit Drivers Appnote w/Desktop Drivers Ver.
               3.4

For more information about ODBC Driver Pack 2.0 Fulfillment Kit, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q125235
   TITLE     : ODBC Driver Pack 2.0 Fulfillment Kit Q&A

For more information about ODBC Drivers, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q140548
   TITLE     : List of ODBC Drivers Installed by Product

Additional query words: inf
Keywords : OdbcOthr kbusage kbfaq
Version : 2.0 7.0 97
Platform : WINDOWS
Hardware : x86
Issue type : kbinfo

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 4, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.