IBM Support

How to create ODBC Connection to Remote Microsoft Access Database.

Troubleshooting


Problem

ODBC Connection for remote MS Access database must use UNC path.

Symptom

Testing Data Source connection fails.

Cause

Incorrectly configured ODBC connection using Mapped Drive location.
Running as a service, the ODBC connection must use a UNC path to the data base.

Resolving The Problem

Stepsn

  1. Start > Control Panel > Administrative Tools > Data Soucres (ODBC)
  2. Select System DNS.
  3. Click Add.
  4. Scroll to and select Microsoft Access Driver (*.mdb)
  5. Click Finish.
  6. Enter a name under Data Source Name.
  7. Under Database, Click Select...
  8. Under Database Name, enter the UNC path to the data base .mdb file.
  9. Click OK three times.
  10. Create the Data Source connection in Cognos Connection > Cognos Administration > Configuration > Data sources.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Connection","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21572219