COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS Connection => Topic started by: JamesJ on 10 Mar 2011 04:46:40 AM

Title: Problem connecting to Mysql database from Framework manager in Cognos 8.4.
Post by: JamesJ on 10 Mar 2011 04:46:40 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.

Any ideas,

Regards

James 
Title: Re: Problem connecting to Mysql database from Framework manager in Cognos 8.4.
Post by: cognostechie on 10 Mar 2011 01:04:03 PM
I had the same problem couple of years ago. It turned out that we have to use an older version of the ODBC driver and that connected properly and I could pull data in Framework Manager. Don't remember the exact version but it was an older one.

At that time, Cognos had declared in the documentation to use Virtual View Manager but I did it using an older version because the client did not have license to VVM.
Title: Re: Problem connecting to Mysql database from Framework manager in Cognos 8.4.
Post by: JamesJ on 11 Mar 2011 04:12:14 AM
Do you know what the settings where? I think you might have used odbc 3.51 I have tried a few settings but still get a fail to connect.
Title: Re: Problem connecting to Mysql database from Framework manager in Cognos 8.4.
Post by: JamesJ on 28 Mar 2011 08:56:39 AM
I found the answer myself for anyone interested I used version 27 of mysql driver 3.51. I tried version 28 but that didn't work but 27 did.

"Perseverance is not a long race; it is many short races one after the other"
Walter Elliot - American Catholic Priest and Writer

"Age wrinkles the body. Quitting wrinkles the soul."
Douglas McArthur
Title: Re: Problem connecting to Mysql database from Framework manager in Cognos 8.4.
Post by: JamesJ on 28 Mar 2011 08:59:06 AM
version 7 not 27
Title: Re: Problem connecting to Mysql database from Framework manager in Cognos 8.4.
Post by: JamesJ on 28 Mar 2011 09:03:46 AM
Its 3.51.27.00, I checked.