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

ID: Q136526

The information in this article applies to:

Microsoft Excel for Windows, versions 5.0, 5.0c
Microsoft Excel for Windows NT, version 5.0
Microsoft Excel for Windows 95, version 7.0
Microsoft Excel 97 for Windows
Microsoft Query for Windows, version 1.0
Microsoft Query for Windows 95, version 2.0
Microsoft Query 97 for Windows

SUMMARY

With Microsoft Excel and Microsoft Query, the Open Database Connectivity (ODBC) drivers that you may use depend on the operating system you are using and whether the program is the 16-bit or 32-bit version.

Microsoft Windows NT

If you are running 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.

The following table lists when to use 16-bit or 32-bit ODBC drivers.


                            Windows NT  Window NT  Windows 95  Windows 95

Program                       16-bit      32-bit     16-bit      32-bit
                              driver      driver     driver      driver
---------------------------------------------------------------------------

Microsoft
Excel 5.0 for Windows 3.1        x           x          x           x

Microsoft
Excel 5.0 for Windows NT                     x                      x

Microsoft
Excel 7.0 for Windows 95                     x                      x

Microsoft
Excel 97 for Windows                         x                      x

Microsoft
Query 1.0 for Windows 3.1        x           x          x

Microsoft
Query 1.0 for Windows NT **      x           x          x

Microsoft
Query 2.0 for Windows 95                     x                      x

Microsoft
Query 97 for Windows                         x                      x

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

Additional query words: 8.00 97 xl97 DAO 16bit 32bit MSQuery XLODBC.XLA


Keywords          : kbualink97 xlquery 
Version           : WINDOWS:1.0,2.0,5.0,5.0c,7.0,97
Platform          : WINDOWS 
Issue type        : kbinfo

Last Reviewed: April 15, 1999