IBM Support

How to create ODBC Connection to Remote Microsoft Access Database.



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


Testing Data Source connection fails.


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


  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":"BU053","label":"Cloud & Data Platform"},"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