ACC: Where to Get Oracle and SQL Server ODBC Drivers

Article translations Article translations
Article ID: 147192 - View products that this article applies to.
This article was previously published under Q147192
Moderate: Requires basic macro, coding, and interoperability skills.

Expand all | Collapse all

On This Page

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.

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 *
                                              
				

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

Properties

Article ID: 147192 - Last Review: August 17, 2007 - Revision: 5.3
APPLIES TO
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition
Keywords: 
kbfaq kbinfo kbusage KB147192
Retired 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.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com