INF: Microsoft SQL Server ODBC Driver Versions
ID: Q152172
|
The information in this article applies to:
-
Microsoft SQL Server versions 4.2x, 6.0, 6.5, 7.0
SUMMARY
This article discusses the different Microsoft SQL Server ODBC Driver
versions and the versions of SQL Server and operating systems they
support.
MORE INFORMATION
The following list shows which versions of the Microsoft SQL Server ODBC
Drivers were included with different versions of SQL Server. It also
lists the operating system versions under which the drivers are certified
to run, and the versions of SQL Server against which they are certified to
work.
Driver Version and Date: 1.02.3231, 10/8/93 (Obsolete; see NOTE below)
Shipped with: OS/2 SQL Server 4.2B
Supported SQL Servers: Microsoft OS/2 SQL Server 1.11 to 4.2B.
Sybase SQL Server 4.0 to 4.9.2
Supported Operating Systems: Windows 3.1, Windows for Workgroups 3.11
Driver Version and Date: 1.02.3731, 1/26/94 (Obsolete; see NOTE below)
Shipped with: SQL Server 4.21
Supported SQL Servers: Microsoft OS/2 SQL Server 1.11 to 4.2B.
Microsoft SQL Server 4.20-4.21 for Windows NT
Sybase SQL Server 4.0 to 4.9.2
Supported Operating Systems: Windows 3.1, Windows for Workgroups 3.11
Driver Version and Date: 2.00.1912, 7/14/94
Shipped with: SQL Server 4.21a
Supported SQL Servers: Microsoft OS/2 SQL Server 4.2 to 4.2b.
Microsoft SQL Server 4.2-4.21a for Windows NT
Supported Operating Systems: Windows 3.1, Windows for Workgroups 3.11,
Windows NT 3.1, 3.50, 3.51
Driver Version and Date: 2.50.0121, 6/7/95
Shipped with: SQL Server 6.0
Supported SQL Servers: Microsoft SQL Server 4.21a and 6.0.
Supported Operating Systems: Windows 3.1, Windows for Workgroups 3.11,
Windows NT 3.50, 3.51, Windows 95
Driver Version and Date: 2.50.0126, 8/17/95
Shipped with: SQL Server 6.0 Service Packs 1, 2, and 3
Supported SQL Servers: Microsoft SQL Server 4.21a and 6.0.
Supported Operating Systems: Windows 3.1, Windows for Workgroups 3.11,
Windows NT 3.50, 3.51, Windows 95
Driver Version and Date: 2.65.0201, 4/3/96
Shipped with: SQL Server 6.5
Supported SQL Servers: Microsoft SQL Server 4.21a to 6.5.
Supported Operating Systems: Windows 3.1, Windows for Workgroups 3.11,
Windows NT 3.50, 3.51, Windows 95
Driver Version and Date: 2.65.0213, 7/30/96
Shipped with: SQL Server 6.5 Service Pack 1
Supported SQL Servers: Microsoft SQL Server 4.21a to 6.5.
Supported Operating Systems: Windows 3.1, Windows for Workgroups 3.11,
Windows NT 3.50, 3.51, Windows 95
Driver Version and Date: 2.65.0240, 12/30/96
Shipped with: SQL Server 6.5 Service Pack 2
Supported SQL Servers: Microsoft SQL Server 4.21a to 6.5.
Supported Operating Systems: Windows 3.1, Windows for Workgroups 3.11,
Windows NT 3.50, 3.51, Windows 95
Driver Version and Date: 2.65.0252, 6/16/97
Shipped with: SQL Server 6.5 Service Pack 3, Service Pack 4,
Service Packs 5 and 5a.
Supported SQL Servers: Microsoft SQL Server 4.21a to 6.5.
Supported Operating Systems: Windows 3.1, Windows for Workgroups 3.11,
Windows NT 3.50, 3.51, 4.0, Windows 95,
Windows 98
Driver Version and Date: 3.70.0623, 11/13/98
Shipped with: SQL Server 7.0, SQL 6.5 Service Pack 5/5a (the
driver was provided in Mdac_typ.exe)
Supported SQL Servers: Microsoft SQL Server version 4.21a or later
Supported Operating Systems: Windows 95, Windows 98, Windows NT 4.0
NOTE: The version 1.02.3231 and 1.02.3731 drivers are no longer provided with any Microsoft products, and are considered obsolete. They were ODBC 1.0 drivers, and as such only had Win16 drivers.
If you have the SQL Server versions listed above, you will have the
corresponding ODBC driver version in the SQL Server client utilities. The
drivers are also included with several applications or development
languages, such as Microsoft Visual Basic, Microsoft Visual C++, and Microsoft Office.
You can also obtain drivers from the Microsoft FTP server at ftp.microsoft.com. Go to the developr/ODBC/public directory. The file Sqldrv.exe is a self-extracting executable file containing the 2.00.1912 driver; the file Sqlsrv32.exe is a self-extracting executable file containing the 2.50.0126 driver. The files Ssrv6532.exe and Ssrv6516.exe are self-extracting executable files containing the Win32 and Win16 versions of the 2.65.0201 driver, respectively.
Starting with SQL Server 6.5 Service Pack 5a and SQL Server 7.0, the SQL Server ODBC Drivers were provided for redistribution in the Microsoft Data Access Components (MDAC) file -- Mdac_typ.exe. Additional information regarding component distribution and supported operating systems can be found in related text documents bundled within the Mdac_typ.exe. For additional information, please see the following article in the Microsoft Knowledge Base:
Q215943 HOWTO: Installing MDAC 2.1 from SP5a of SQL Server 6.5
The 2.50.0126 SQL Server driver is also in the SQL Server 6.0 Service Packs
2 and 3. For information on obtaining the service pack, query on the
following word in the Microsoft Knowledge Base (without the spaces):
S E R V P A C K
Additional query words:
Fetch open database connectivity
Keywords : SSrvGen kbODBC
Version : winnt:4.2x,6.0,6.5,7.0
Platform : winnt
Issue type : kbinfo