Performing an Administrative Setup of the ODBC 2.0 Kit

ID: Q140115

2.00 WINDOWS PUBLIC | kbtool kbsetup

The information in this article applies to:

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"

KBCategory: kbtool kbsetup KBSubcategory:

Additional reference words: 2.00

Version           : 2.00
Platform          : WINDOWS

Last Reviewed: September 14, 1996