INF: Network Setup of ODBC Drivers

 Last reviewed: September 9, 1996
Article ID: Q110471
The information in this article applies to:
  • Microsoft Open Database Connectivity, version 1.0

SUMMARY

As is typical in network installations of software, the ODBC setup program cannot be used to install the ODBC components on a file server with just the .INI files being installed on the client computers. The ODBC Setup program, however, can be used by administrators to simplify the installation of ODBC components on client computers.

This article explains how to use a setup option to make multi-client ODBC installations simple. Note that all the ODBC components will be installed on every client workstation.

MORE INFORMATION

The Setup program that ships with ODBC drivers in Microsoft products, such as Microsoft Access and Visual Basic, has an option called 'auto,' which, given a valid ODBC installation on a client workstation, makes it simple to duplicate the same ODBC setup on other client computers.

Follow the steps below to install the ODBC components on multiple client computers:

  1. Install the ODBC drivers and add the required data sources on a client computer.

  2. Create a directory on a network file server and copy all the files on the ODBC setup disk into this directory.

  3. Copy the ODBC.INI and ODBCINST.INI files created by Setup in step 1 to this new directory.

  4. Modify the SETUP.LST file on the file server so that the following two lines are added to the [Files] section: 

          odbc.ini = odbc.ini
      odbcinst.ini = odbcinst.ini

  5. From the client computers, connect to this network share and run Setup with the Auto option from the share.

All the drivers and data source entries will be copied to the client s workstation. Note that any data sources that exist on the client workstation before running setup/auto will remain in the client s ODBC.INI file. If the client workstation did not have any ODBC components or .INI files, setup/auto will create the new .INI files and copy all the drivers from the network drive to the client computer.

Additional reference words: 1.00 odbc 2.0 net install
KBCategory: kbnetwork kbsetup
KBSubcategory: odbc



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 9, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.