book
Article ID: KB0078598
calendar_today
Updated On:
Description
You have a TIBCO Scribe® Insight DTS with a Source ODBC connection to a Microsoft Access database. The DTS runs successfully in the TIBCO Scribe® Insight Workbench, but it fails to connect when it is run as a File Integration Process in the Console with this error message:
Failed to connect to database. Error in Execution Log: Message Processor error: Error opening data source [data source name].
Resolution
When you run your DTS from the TIBCO Scribe® Insight Workbench, you are using the permissions of your currently logged in Windows account. This changes when you configure the Integration Process to run in the TIBCO Scribe® Insight Console. The TIBCO Scribe® Insight Console uses the Scribe services logon user to determine the permissions to run your Integration Process.
To resolve this issue:
- Confirm that the Scribe services logon account is a domain account, a member of the local administrators and Scribe Console Users groups, and has permissions for the Access database.
- Confirm that your 32-bit ODBC connection is using a System DSN.
- Configure the ODBC connection with a UNC path rather than a mapped drive.
Configuring the ODBC Connection
- Launch the ODBC Data Source Administrator (32-bit) tool under Control Panel > Administrative Tools > ODBC Data Sources (32-bit).
- Select the System DSN tab.
- Select your System Data Source, and click Configure.
- In the ODBC Microsoft Access Setup window, Database section, click Select…
- In the Database Name field, enter (or copy/paste) the UNC path for your Access database
UNC path for my Access DB: \\your_server\your_folder\Test_Connect.mdb
- Click OK to save.
Issue/Introduction
Use this article to troubleshoot ODBC Source Connection Errors To Microsoft Access Databases when using TIBCO Scribe® Insight.
Additional Information
For additional information, see the following:
TIBCO Scribe® Insight Help:
Connecting To An ODBC Data Source,
Troubleshooting An ODBC Source Connection