MYSQL Connection Issue

[Sugs]

Hi,

I have tried connecting to Mysql through Cognos Connection but get a Failure to Connect message.
I have installed and tried the two Mysql drivers (3.51 and 5.1) and tested the ODBC connection and they both connect successfully but when I open Cognos Connection I get a Failed message.

Help anybody?

[vasadikiran]

Hi,

This will helps you

http://baliyansandeep.blogspot.com/2010/04/cognos-data-source-connection-to-mysql.html


Kiran vasadi

[MFGF]

The only other thing that springs to mind is if you are running a 64-bit OS.  Have you configured the MySQL ODBC driver using the 64-bit ODBC administration console, or the 32-bit ODBC administration console?  If this is the problem, locate odbcad32.exe and launch it manually to get into the 32-bit console, and configure your ODBC connection there.

Regards,

MF.