Set up a data source that uses the Microsoft ODBC for Oracle driver

Microsoft Query

Show All Show All

Set up a data source that uses the Microsoft ODBC for Oracle driver

By using the Microsoft ODBC for Oracle driver, you can connect to Oracle databases that support SQL*Net 2.3 or later. For information about this support, see your Oracle documentation.

Before you can set up data sources that use this driver, you must install Oracle client and networking components version 7.3 or later. These components are available from Oracle or your Oracle vendor.

  1. If the Create New Data Source dialog box is not displayed, click New on the File menu, click the Databases tab, and then double-click New Data Source. Type a name for the data source in step 1, and select Microsoft ODBC for Oracle Driver in step 2.
  2. In step 3, click Connect.
  3. Under Database, click Select.
  4. In the User name box, enter your database logon name.
  5. Enter the name of your Oracle server and any additional information necessary to connect to the server. See your Oracle database administrator for this information. For information about setup options, click Help in the setup dialog box.
  6. Enter your logon ID and password, and then click OK twice.