Article ID: 147192 - Last Review: August 17, 2007 - Revision: 5.3

ACC: Where to Get Oracle and SQL Server ODBC Drivers

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
This article was previously published under Q147192
Moderate: Requires basic macro, coding, and interoperability skills.

On This Page

Expand all | Collapse all

SUMMARY

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.
Back to the top

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 9x                       for the Win16 Client from
             Windows 2000                     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 9x                       the clients folder on the
             Windows 2000                     Microsoft SQL Server CD.

   7.0       Windows 9x           4.21a/6.x   Microsoft Access 7.0
             Windows NT 3.51/4.x              ODBC Drivers App note from
             Windows 2000                     the clients folder on the
                                              Microsoft SQL Server CD

   97        Windows 9x           4.21a/6.x   Microsoft Access 97
             Windows NT 3.51/4.x              Microsoft Data Access
             Windows 2000                     Components *
                                              The clients folder on the
                                              Microsoft SQL Server CD

   2000      Windows 9x           6.5/7.0     Microsoft Access 2000
             Windows NT 4.x                   Microsoft Data Access
             Windows 2000                     Components *
Back to the top

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 9x                        ODBC Fulfillment Kit
             Windows NT 3.51
             Windows 2000
 
    2.0      Windows 3.1         7.0           ODBC Fulfillment Kit
             WFW 3.1             SQL Net 1.x
             Windows 9x
             Windows NT 3.51
             Windows 2000

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

    7.0      Windows 9x          7.x           Microsoft ODBC Drivers
             Windows NT 3.51/4.x               Available in Microsoft
                                               Windows 2000
                                               Download Center

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

  2000       Windows 9x          7.x           Microsoft Data Access
             Windows NT 4.x                    Components *
             Windows 2000
* You can download the Latest Microsoft Data Access Components at the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e (http://www.microsoft.com/downloads/details.aspx?familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e)
Back to the top
APPLIES TO
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition
Back to the top
Keywords: 
kbfaq kbinfo kbusage KB147192
Back to the top
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations