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

ID: Q147192

The information in this article applies to:

SUMMARY

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

This article lists Microsoft SQL Server and ORACLE ODBC drivers that 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 App note from
                                              the clients folder on the
                                              Microsoft SQL Server CD

   97        Windows 95           4.21a/6.x   Microsoft Access 97
             Windows NT 3.51/4.x              Microsoft Data Access
                                              Components *
                                              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          7.x           Microsoft ODBC Drivers.
             Windows NT 3.51/4.x               Available on MSL.

    97       Windows 95          7.x           Microsoft Data Access
             Windows NT 3.51/4.x               Components *

* You can download the Microsoft Data Access Components on the

Microsoft World Wide Web site at:

http://www.microsoft.com/data/download.htm
For information on obtaining the Microsoft ODBC Drivers, please see the following article in the Microsoft Knowledge Base:

Q149961 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:

Q140498 INF: Using the Visigenic ORACLE Driver on WinNT & Win95


REFERENCES

For more information about ODBC 32-Bit Drivers w/Desktop Drivers Version 3.4, please see the following article in the Microsoft Knowledge Base:

Q139487 WX1220: ODBC 32-Bit Drivers 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:

Q125235 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:

Q140548 List of ODBC Drivers Installed by Product

Additional query words: inf latest drivers ODBC most recent 


Keywords          : kbusage OdbcOthr 
Version           : WINDOWS:2.0,7.0,97
Platform          : WINDOWS 
Issue type        : kbinfo

Last Reviewed: July 15, 1999