ODBC Source Connection Error To Microsoft Access Database

ODBC Source Connection Error To Microsoft Access Database

book

Article ID: KB0078598

calendar_today

Updated On:

Products Versions
TIBCO Scribe Insight 7.9.1

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].

 

    Issue/Introduction

    Use this article to troubleshoot ODBC Source Connection Errors To Microsoft Access Databases when using TIBCO Scribe® Insight.

    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:
    1. 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.
    2. Confirm that your 32-bit ODBC connection is using a System DSN.
    3. Configure the ODBC connection with a UNC path rather than a mapped drive.


    Configuring the ODBC Connection
     

    1. Launch the ODBC Data Source Administrator (32-bit) tool under Control Panel > Administrative Tools > ODBC Data Sources (32-bit).
    2. Select the System DSN tab.
    3. Select your System Data Source, and click Configure.
    4. In the ODBC Microsoft Access Setup window, Database section, click Select…
     
    kA2320000004GlGCAU_en_US_1_0
     
    1. 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
    1. Click OK to save.
     
    kA2320000004GlGCAU_en_US_1_1

     

    Additional Information

    For additional information, see the following:

    TIBCO Scribe® Insight Help: Connecting To An ODBC Data Source, Troubleshooting An ODBC Source Connection
    Powered by Wolken Software