Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

ODBC Administrator

ODBC Administrator registers and configures the data sources available to you either locally or across a network. The wizards use information supplied by ODBC Administrator to create code in your applications that connects your users to data sources.

To set up an ODBC data source for use with either the MFC ODBC classes or the MFC Data Access Object (DAO) classes, you must first register and configure the data source. Use ODBC Administrator to add and remove data sources. Depending on the ODBC driver, you can also create new data sources.

ODBC Administrator is installed during Setup. If you chose Custom Installation and did not select any ODBC drivers in the Database Options dialog box, you need to run Setup again to install the necessary files.

During Setup, you select the ODBC drivers you want to install. You can later install additional drivers that ship with Visual C++ using the Visual C++ Setup program.

If you want to install ODBC drivers that do not ship with Visual C++, you must run the setup program that accompanies the driver.

To install ODBC drivers that ship with Visual C++

Note   This procedure assumes that you have already installed Visual C++ and are rerunning Setup to add the ODBC drivers that ship with Visual C++.
  1. Run Setup from your Visual C++ distribution CD.

    This displays the opening dialog box in the Setup program.

  2. Click Next on each dialog box until you reach the Installation Options dialog box. Select the Custom radio button and click Next.
  3. Clear all the check boxes on the Microsoft Visual C++ Setup dialog box except the Database Options check box. Click Details to display the Database Options dialog box.
  4. Clear the Microsoft Data Access Objects check box, select the Microsoft ODBC Drivers check box, and click Details.

    This displays the Microsoft ODBC Drivers dialog box.

  5. Select the drivers you want to install, and then click OK twice.
  6. Click Next on the remaining dialog boxes to begin the installation. Setup notifies you when the installation is complete.

Once the drivers are installed, you can configure the data source using the ODBC Administrator. You will find the ODBC icon in Control Panel. For information about configuring a data source with ODBC Administrator, see the Open Database Connectivity (ODBC) SDK in the MSDN documentation.

See Also

Overview: Open Database Connectivity (ODBC) | Data Source (ODBC)

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.