English

How To: Make an OLE DB connection to a file-based ODBC DSN

Summary

Instructions provided are for creating an OLE DB connection to an ODBC data source using a file-based DSN (data source name).

Procedure

  1. Double-click 'Add OLE DB Connection' item in ArcCatalog or ArcMap.
  2. Make sure the default OLE DB provider, MicroSoft OLE DB Provider for ODBC Drivers, is selected and click Next.
    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
  3. Select the 'Use Connection String' radio button on the Connection Tab.
    [O-Image] Using file based ODBC DSNs.
    .
  4. Click Build. Select either an existing DSN file or create a new one.
    Generating ODBC connection string from a file based ODBC DSN.

    [O-Image] Connection string for file DSNs
  5. Check the Allow saving password box if the connection requires a password.
    Check the Allow saving password option before exiting from the Data Link Utilities dialog box.

    [O-Image] Password check for file DSNs
    .
  6. Test the connection and click OK. A new OLE DB connection item is added to the Catalog tree.