ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Adding OLE DB connections to databases

OLE DB connections in ArcGIS are used to make read-only connections to tabular data sources. This type of connection is most commonly used to connect from ArcGIS to data sources that support OLE DB but cannot be accessed from the Database Connection dialog box in ArcGIS for Desktop.

You can create and manage OLE DB connections by adding the Add OLE DB connection button to a toolbar in ArcCatalog. Connection files created from this button are listed in the Database Connections folder in the Catalog tree.

  1. Start ArcCatalog.
  2. Add the OLE DB Connection command as a button to a toolbar in ArcCatalog.
    1. Click Customize on the main menu and click Customize mode.

      The Customize dialog box opens.

    2. Click the Commands tab.

      Choose Add OLE DB Connection command

    3. Choose ArcCatalog from the Categories list.
    4. Drag Add OLE DB Connection from the Commands list onto a toolbar in ArcCatalog.

    The Add OLE DB Connection button is added to the toolbar.

  3. Click Close on the Customize dialog box.
  4. Click the Add OLE DB Connection button.

    The Data Link Properties dialog box appears in which you can create an OLE DB connection.

    Creating an OLE DB connection

  5. Click the OLE DB provider you want to use to access data.
  6. Click Next or click the Connection tab.
  7. Provide the required connection information. The Connection tab is different for each provider. Most require that you identify the database to which you want to connect along with your user name and password.
  8. Click Test Connection to validate that you have entered connection information correctly.
  9. Click OK once your test is successful.

    The OLE DB data source you added is displayed in the Database Connection folder. Click F5 to refresh the Catalog tree if the connection does not display.

  10. Name your OLE DB connection.

You can now work with the tabular data in the database.

Related Topics

  • What is the Catalog window?
  • What is ArcCatalog?
Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal