Microsoft KB Archive/152172

{|
 * width="100%"|

INF: Microsoft SQL Server ODBC Driver Versions

 * }

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

Issue type : kbinfo

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600 kbSQLServ700 kbSQLServ650 kbSQLServ420OS2