Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL: Using 16-Bit and 32-Bit ODBC Drivers

XL: Using 16-Bit and 32-Bit ODBC Drivers

View products that this article applies to.

This article was previously published under Q214275

↑ Back to the top

Summary

Microsoft Excel 2000 and Microsoft Query 2000 (and later) are both 32-bit programs and use 32-bit Open Database Connectivity (ODBC) drivers. With versions of Microsoft Excel earlier than Excel 7.0 and Microsoft Query earlier than Query 2.0 that were designed to operate with the Microsoft Windows 3.1 operating system, the ODBC drivers that you can use depend on the operating system that you are using and whether the program is the 16-bit or 32-bit version.

Microsoft Windows NT

If you are running Microsoft Windows NT, 16-bit programs can use either 16-bit or 32-bit ODBC drivers; 32-bit programs can use only 32-bit ODBC drivers.

Microsoft Windows 95

If you are running Windows 95, 16-bit programs can use only 16-bit ODBC drivers and 32-bit programs can only use 32-bit ODBC drivers.

Microsoft Windows 98 and Microsoft Windows Millennium Edition (Me)

If you are running Windows 98 or Windows Me, and you must run 16-bit drivers, you need to use the 16-bit drivers that come from individual manufacturers. In the \Windows folder, a list of 32-bit driver files that may be used to replace 16-bit drivers is contained in the Ios.ini file. All the versions of Excel and Query listed below can use the 32-bit ODBC drivers with Windows 98 or Windows Me.

Microsoft Windows 2000

If you are running Windows 2000, and you must run 16-bit drivers, you need to use the 16-bit drivers that come from individual manufacturers. In the \Windows folder, a list of 32-bit driver files that may be used to replace 16-bit drivers is contained in the Ios.ini file. All the versions of Excel and Query listed below can use the 32-bit ODBC drivers with Windows 2000.

The following table lists when to use 16-bit or 32-bit ODBC drivers. 
                                 Windows NT - NT4       Windows 95 - 2000  

   Program                       16-bit      32-bit     16-bit      32-bit
                                 driver      driver     driver      driver
   ------------------------------------------------------------------------
   Excel 5.0 for Windows 3.1        x           x          x           x

   Excel 5.0 for Windows NT                     x                      x

   Excel 7.0 for Windows 95                     x                      x

   Excel 97 for Windows                         x                      x

   Excel 2000                                   x                      x

   Query 1.0 for Windows 3.1        x           x          x

   Query 1.0 for Windows NT **      x           x          x

   Query 2.0 for Windows 95                     x                      x

   Query 97 for Windows                         x                      x

   Query 2000                                   x                      x

   Query 2002                                   x                      x
** Microsoft Query version 1.0 that is provided with Microsoft Excel 5.0 for Windows NT is 16-bit.

↑ Back to the top

Keywords: KB214275, kbualink97, kbhowto

↑ Back to the top

Article Info
Article ID : 214275
Revision : 5
Created on : 1/24/2007
Published on : 1/24/2007
Exists online : False
Views : 378