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
------------------------------
Original Message:
Sent: Wed August 21, 2019 12:59 PM
From: Krishna Tammana
Subject: Urgent: CA 11.1.1: SQL Server DataSource Error
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