topic How i can manage connexion to database MySQL ODBC 5.1? in QlikView

How i can manage connexion to database MySQL ODBC 5.1?

Mon, 16 Jul 2012 09:23:27 GMT

How i can manage connexion to database?

I have theses informations for connection :

DRIVER={MySQL ODBC 5.1 Driver};UID=generix;PWD=gnx;SERVER=10.5.3.33;DATABASE=mantis;PORT=3306;

and I would like to creat new pilote :

But it doesn't work.

I tried differents way, but no succes.

I use a VPN to acces to the database... may be the problem comes from here no?

Someone has an idea?

thanks

stéphane

Re: How i can manage connexion to database MySQL ODBC 5.1?

Mon, 16 Jul 2012 10:00:44 GMT

Hi Stéphane,

from the driver connection string it appears that your database is MySql, but you are trying to create connection to MS SQL database. Which one is correct?

regards

Re: How i can manage connexion to database MySQL ODBC 5.1?

Mon, 16 Jul 2012 10:03:26 GMT

I downloaded SQL ODBC 5.1 Driver, and tested it again, with no success :,

Re: How i can manage connexion to database MySQL ODBC 5.1?

Mon, 16 Jul 2012 10:10:31 GMT

On the following link is the list of possible issues why that error message occured:

http://wiki.answers.com/Q/What_does_MySQL_error_number_10060_mean

regards

Re: How i can manage connexion to database MySQL ODBC 5.1?

Sun, 22 Jul 2012 11:06:08 GMT

I've found it. it was a problem with server.