Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
Back to discussions
Expand all | Collapse all

MS Acess database data source is not working in Cognos 11.0.13

  • 1.  MS Acess database data source is not working in Cognos 11.0.13

    Posted Mon April 20, 2020 02:28 PM
    we tried to create data source against to ms access database (.mdb file) it's failing. we are able to access ms-access db but creating an connection throwing an errros.

    ------------------------------
    Rajitha Kalluri
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: MS Acess database data source is not working in Cognos 11.0.13

    Posted Tue April 21, 2020 03:53 AM

    Hi Rajitha,

    depending on the error it could be caused either by the ODBC or missing permissions to MySysXXXXX tables.
    For ODBC connections IBM Cognos requires a 32-bit ODBC connection.

    Regards
    Gertrud



    #CognosAnalyticswithWatson