COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: ZurdoVzla on 09 Sep 2016 10:34:41 AM

Title: ODBC Data Source CA
Post by: ZurdoVzla on 09 Sep 2016 10:34:41 AM

Hi,

I had installed CA 11.03 on WS 2008, as Content Store SQL Server 2012.

I need to create a Data Source to conect with a DB in SQL Server 2008R2. I'm trying to doing this choosing a Microsoft SQL Server (ODBC) and check box JDBC.

After fill the parameter for both connection, the test throws Failed for Compatible mode(ODBC) and Correct for Dynamic mode (JDBC). How can I fix the Compatible mode??

The error is QE-DEF-0285 logon failed.

ODBC Parameters:
  ODBC data source: the name of the odbc created with microsoft odbc tool (indicate succesful with the test).
  Time outs: 180 & 180 seconds.
  The rest of the parameter are blank, however, in both connections (odbc & jdbc) the signon is the same.

Any help, advise or suggestion...

Thanks