PRB: 16-bit Installer May Create Bad ODBCINST.INI & ODBC.INI

• Microsoft Open Data Base Connectivity, version 2.10

SYMPTOMS

When a 16-bit Installer, that is, ODBCINST.DLL, is used to install 16-bit drivers on a Windows NT computer without any ODBC components, SQLInstallODBC will fail and a bad ODBCINST.INI file will be created.

If the ODBC.INF file contains data source information, SQLInstallODBC fails with one more bad ODBC.INI file.

If SQLConfigDataSource is called after SQLInstallODBC, instead of specifying data source information in the ODBC.INF, SQLConfigDataSource will fail with the same result.

One symptom is that, after the installation, driver information will not be available when you click "About," and no data source is listed in the data source window in the 16-bit ODBC Administrator.

WORKAROUND

1) Manually modify the ODBC.INI and ODBCINST.INI files after the

   installation.

2) Use a resource editor to modify the comment lines in the ODBCINST.DLL

   file directly.

1. Launch App Studio.

   ODBC.." comment line;

   ";--------------------------------------------"
   to:
   ";------------------------------------------\r\n"

You will now get a correct version of ODBCINST.DLL.

MORE INFORMATION

The following are examples of bad ODBCINST.INI and ODBC.INI files. You can see that newline characters are missing from the last comment line:

++++++++++++ Beginning of ODBCINST.INI +++++++++++++++++++++ ;-------------------------------------------------------------------------

; WARNING:Do not make changes to this file without using the ODBC Control

;         panel device or other utilities provided for maintaining data
;         sources.
;
;         Incorrect changes to this file could prevent ODBC from
;         operating or operating correctly.

Driver=C:\WINNT35\SYSTEM\odbcjt16.dll Setup=C:\WINNT35\SYSTEM\odbcjt16.dll SQLLevel=0 FileExtns=*.mdb FileUsage=2 DriverODBCVer=02.01 ConnectFunctions=YYN APILevel=1 . . . ++++++++++++ End of ODBCINST.INI +++++++++++++++++++++

++++++++++++ Beginning of ODBC.INI +++++++++++++++++++++ ;------------------------------------------------------------------------- ; WARNING:Do not make changes to this file without using the ODBC Control

;         panel device or other utilities provided for maintaining data
;         sources.
;
;         Incorrect changes to this file could prevent ODBC from
;         operating or operating correctly.

MyAccess=Microsoft Access Driver (*.mdb) [MyAccess] Driver=C:\WINNT35\SYSTEM\odbcjt16.dll DriverId=25 FIL=MS Access; JetIniPath=odbcddp.ini UID=admin ++++++++++++ End of ODBC.INI +++++++++++++++++++++