Cognos Express with Mysql Datasource

[ananrv]

I have a Doubt in Cognos Express:
i have installed Cognos express in Windows server and i have installed framework in local desktop. In Cognos server machine have a access to connect Database server (Mysql) so i have created ODBC and test connection also is working fine.
While i am using framework manger it shows all datasource list but i am unable to connect datasource
it shows below error
QE-DEF-0285 The logon failed.
QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
prcaseinterface

UDA-SQL-0031 Unable to access the "testdatasource" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.
UDA-SQL-0532 Data Source is not accessible: "testdatasource".
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

In my local desktop don't have access to Database server.

Please help me to resolve this issue.

[MFGF]

I have a Doubt in Cognos Express:
i have installed Cognos express in Windows server and i have installed framework in local desktop. In Cognos server machine have a access to connect Database server (Mysql) so i have created ODBC and test connection also is working fine.
While i am using framework manger it shows all datasource list but i am unable to connect datasource
it shows below error
QE-DEF-0285 The logon failed.
QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
prcaseinterface

UDA-SQL-0031 Unable to access the "testdatasource" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.
UDA-SQL-0532 Data Source is not accessible: "testdatasource".
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

In my local desktop don't have access to Database server.

Please help me to resolve this issue.

Hi,

If you're using an ODBC connection, that means you're using Express's Compatible Query Mode (CQM). With CQM, Framework Manager has its own local instance of the query engine embedded within it, and it uses this to connect to the data source for modelling purposes. Since FM is installed on your local machine, this means you will need the same ODBC connection to be configured on your local machine as on the Express server.

Cheers!

MF.

[ananrv]

Dear MF,

In Local machine i don't have access to the Database Server. Only server to server connection only possible.
In this case how can i connect Datasource using server side Datasource connection.

Note: The same case SPSS is working fine. client application able to connect datasource using server side datasource.

Regards,
A.Anand

[MFGF]

Dear MF,

In Local machine i don't have access to the Database Server. Only server to server connection only possible.
In this case how can i connect Datasource using server side Datasource connection.

Note: The same case SPSS is working fine. client application able to connect datasource using server side datasource.

Regards,
A.Anand

Hi,

As I explained, you can't connect via the server-defined connection if you use ODBC. That's not the way it works in Framework Manager with a CQM connection. If you can find a way to connect via JDBC instead of ODBC then you will be using Dynamic Query Mode (DQM) and this connects via the server not via a local connection.

I'd suggest the easiest solution is to install the ODBC client on your local machine and set up an ODBC connection.

MF.