Connect to an Access Database

In this exercise, you make a connection to the Microsoft Access database for the Sheboygan parcels data and save the connection as a resource.

  Detailed steps
  1. Right-click the Data folder in the Site Explorer and then click NewData Connection.
  2. In the Connect to Data dialog box, select OSGeo FDO Provider for ODBC.
  1. In the New Feature Source Editor, for Type Of Connection, select Connect To A File And Upload To The Map Server Library.
  2. Under Data File And Any Associated Files To Be Uploaded, click New and then navigate to the folder: C:\Program Files\Autodesk\Autodesk Infrastructure Studio 2013\Sample Data\Database.
  3. Select Parcels.mdb. Click Open.
  1. Click FileSave and save the connection resource in the Data folder with the name Access database connection.
  2. It may take a minute for the file to upload to the server.

    Click Test Connection.

    You should see a “Successful Connection” message.

  3. Close the resource editor.