Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: Sugs on 14 Mar 2011 05:54:55 AM

Title: MYSQL Connection Issue
Post by: Sugs on 14 Mar 2011 05:54:55 AM
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?
Title: Re: MYSQL Connection Issue
Post by: vasadikiran on 29 Mar 2011 03:34:36 AM
Hi,

This will helps you

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


Kiran vasadi
Title: Re: MYSQL Connection Issue
Post by: MFGF on 01 Apr 2011 06:46:26 AM
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.
Text only | Text with Images