Performing an Administrative Setup of the ODBC 2.0 Kit (140115)

SUMMARY

In a multi-user environment, a network administrator can configure the 16- bit ODBC desktop database drivers to be set up automatically from a network drive. Automatic setup provides all users with the same ODBC drivers and data sources.

NOTE: The automatic setup procedure can be used to set up the 16-bit ODBC desktop database drivers, but it cannot be use to set up the 32-bit drivers.

To configure the ODBC desktop database drivers for automatic setup

Create a directory on the server.
Copy the contents of the Microsoft ODBC 16-Bit Database Drivers Disk 1, Disk 2, and Disk 3 to this directory. For example, if the newly created directory is "F:\ODBC," type the following at the MS-DOS prompt:
copy a:*.* f:\odbc
On a computer that does not have ODBC installed, install the ODBC desktop database drivers and add all the data sources your users will need.

NOTE: You must install these drives to a computer that does not have ODBC installed; otherwise, you may encounter problems using the automatic setup.
Copy the Odbc.ini and Odbcinst.ini files from the computer used in the Step 3 to the network directory created in Step 1. For example, if the network directory is "F:\ODBC", type the following at the MS-DOS prompt:
copy c:\windows\odbc.ini f:\odbc copy c:\windows\odbcinst.ini f:\odbc
With a text editor such as Notepad, add the following two lines to the [Files] section of the SETUP.LST file on the network directory:
Odbcinst.ini = Odbcinst.ini Odbc.ini = Odbc.ini

To run automatic setup at a workstation

Start Windows, and connect to the network drive containing the ODBC desktop database drivers.
In Program Manager, click Run on the File menu.
Type the following
f:\odbc\setup /auto
and click OK (where "F:\ODBC" is the network directory containing the ODBC Desktop Database Drivers).

MORE INFORMATION

The following sections describe error messages you may receive when you run automatic setup.

Setup is unable to install ODBC.
C:\~BRZSTP.T\Odbcinst.ini is either empty or missing.

You receive this error message immediately after running "Setup /Auto" if you attempt to run an automatic setup and you have not copied the Odbc.ini and Odbcinst.ini files to the network directory and edited Setup.lst.

Setup is unable to create data sources.
C:\~BZRSTP.T\Odbc.ini is either empty or missing.

You receive this error message after all files have been copied during setup if the Odbc.ini file copied to the network directory does not contain any data sources.

Setup was unable to install the ODBC drivers