English

How To: Use the Microsoft OLE DB provider for ODBC drivers to connect to an Oracle database

Summary

Instructions provided are for making a connection to an Oracle database using the Microsoft OLE DB provider for ODBC drivers.

Procedure

  1. Use an existing Oracle ODBC DSN (data source name) or set up a new Oracle ODBC DSN using the Windows Data Sources (ODBC) utility and an appropriate ODBC driver.
  2. Once the DSN is created, double-click the Add OLE DB connection option from within ArcCatalog or ArcMAP to call the Data Link Properties menu.
  3. On the first panel, make sure the Microsoft OLE DB provider for ODBC drivers is selected. This is the default option.
    Microsoft OLE DB Providers are included with ArcGIS.

    Note:
    The list may be different than this example, as proprietary and third-party OLE DB providers for other data sources may be installed on the machine being used.


    [O-Image] DataLink Properties - Provider tab
  4. Click the Connection tab.
    Select 'Use data source name'.
    Select the DSN item to be used.
  5. Add a valid RDBMS username and password in the appropriate boxes.
    Check the Allow saving password box.
    The DataLink Properties sheet (Connection tab) when using the Microsoft OLE DB Provider for ODBC. Enter the Username and Password for connections that require them (Oracle, SQL Server, etc.)

    [O-Image] DataLink Properties - Connection Tab
  6. Verify the new connection by clicking Test Connection. Close the Data Link Properties menu. You will see a new OLE DB connection object under Database Connections in the TOC.