Microsoft KB Archive/140115

= Performing an Administrative Setup of the ODBC 2.0 Kit =

Article ID: 140115

Article Last Modified on 10/24/2000

-

APPLIES TO


 * Microsoft Open Database Connectivity Desktop Database Driver Kit 2.0

-



This article was previously published under Q140115



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.</li> In Program Manager, click Run on the File menu.</li> Type the following

f:\odbc\setup /auto

and click OK (where "F:\ODBC" is the network directory containing the ODBC Desktop Database Drivers).</li></ol>

<div class="moreinformation_section">

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.

<div class="references_section">