Performing an Administrative Setup of the ODBC 2.0 Kit

• Microsoft ODBC 2.0 Desktop Database Drivers

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

1. Create a directory on the server.

2. 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
   

3. 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.
   

4. 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
   

5. 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

1. Start Windows, and connect to the network drive containing the ODBC desktop database drivers.

2. In Program Manager, click Run on the File menu.

3. 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

You may receive the following error message at the beginning of setup, before any files are copied, if the Odbcinst.ini file copied to the server contains information that is incorrect or information that is specific to drivers that are not installed with the ODBC 2.0 Desktop Database Drivers.

REFERENCES

"Getting Started: Microsoft ODBC Desktop Database Drivers", version 2.0, Chapter 2, "Setting Up ODBC Desktop Database Drivers"