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
- Start > Control Panel > Administrative Tools > Data Soucres (ODBC)
- Select System DNS.
- Click Add.
- Scroll to and select Microsoft Access Driver (*.mdb)
- Click Finish.
- Enter a name under Data Source Name.
- Under Database, Click Select...
- Under Database Name, enter the UNC path to the data base .mdb file.
- Click OK three times.
- 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"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21572219