Cognos Analytics

 View Only
  • 1.  Urgent: CA 11.1.1: SQL Server DataSource Error

    Posted Wed August 21, 2019 01:00 PM
      |   view attached
    Hi,

    CA 11.1.1 / SQL Server 2014 -- Data Source failing. Please suggest.

    Error: Screen shot attached.

    JDBC Driver installed and copied to Drivers folder in installation directory.

    Thanks,
    Krish

    ------------------------------
    Thank you,
    Krish
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Urgent: CA 11.1.1: SQL Server DataSource Error

    Posted Wed August 21, 2019 01:23 PM

    Hi Krish,
    You're using the 'old-style' connection configuration pages, which allow for setting up connections for Compatible Query Mode(CQM) and Dynamic Query Mode.(DQM)
    It looks like your CQM connection is not working, but the DQM connection is.
    When you're creating models in Framework Manager, the default is to use DQM, when creating Data Modules with the Web-based Modeling UI, it always uses DQM.
    If you do not need CQM, you can proceed with what you have. As an alternative, you can recreate the connection with the new Data Server Configuration tools, which do not allow you to create CQM connections.

    Kind regards,
    Henk



    ------------------------------
    HENK CAZEMIER
    ------------------------------



  • 3.  RE: Urgent: CA 11.1.1: SQL Server DataSource Error

    Posted Thu August 22, 2019 09:25 AM
    Henk,

    Thank You for your response. We are in the process of migrating from Cognos 10.2 and the reports are failing because CQM connection is not working.  I need this to be fixed. Any other suggestions.

    New packages we can go with DQM.

    Thanks,
    Krish

    ------------------------------
    Thank you,
    Krish
    ------------------------------



  • 4.  RE: Urgent: CA 11.1.1: SQL Server DataSource Error

    Posted Thu August 22, 2019 09:43 AM
    Hi Krish,
    Does the CQM connection string look similar to the following?
    This works for me on a machine that is running SQL Server 2014.
    // Henk



    ------------------------------
    HENK CAZEMIER
    ------------------------------



  • 5.  RE: Urgent: CA 11.1.1: SQL Server DataSource Error

    Posted Thu August 22, 2019 11:15 AM
    Hi,

    Issue Resolved by installing SQL Server Native Client from Microsoft website.

    https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client?view=sql-server-2014

    Thank you for your help HENK,
    Krish

    ------------------------------
    Thank you,
    Krish
    ------------------------------



  • 6.  RE: Urgent: CA 11.1.1: SQL Server DataSource Error

    Posted Wed August 28, 2019 06:30 AM

    The connection in your error is being routed to compatible query engine and not dynamic query.

    The connection therefore is attempting to use the SQL Server OLE-DB client (part of SQL Native client install).

    Windows is failing to load the OLE-DB client most likely because you do not have the correct version installed.



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------