Data source connection to MYSQL Database using ODBC

[mewyeen]

I have created an ODBC Data Source in the Windows System Data Source using the MySQL ODBC 5.1 Driver.  Tested the connection succesfully.

I try to create a new data source in Cognos by only ODBC and only specify the ODBC data source without the ODBC connect string or collation sequence.  Test the connection and the status is faild.  The message as below:

DPR-ERR-2072 The request failed.  It was directed to a server that is not reachable.

1.  Could it be that I didn't specify the ODBC connect string and collation sequence?

2.  If yes, what should be the value?

3.  If no, what could be the problem?

Thank you.

[mewyeen]

Found that only MySQL ODBC driver version 3.51 is work for Cognos 8.  Version 5.1 is not compatible.

[nishadhawn]

for mysql data source to work with Cognos 8.3, did you also do any cogdmod.ini settings and can you please let me know the configuration settings you have done.

thanks

[spablos]

Found that only MySQL ODBC driver version 3.51 is work for Cognos 8.  Version 5.1 is not compatible.

What are the fields you used on the cognos interface for the data source connection, i mean:
Connection String , collation ....
Did you defined an ODBC connection through the windows interface also? ....