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

• 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 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 in Microsoft Download Center

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

* You can download the Microsoft Data Access Components at the following Microsoft Web site:

http://www.microsoft.com/data/download.htm

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

REFERENCES

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

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