Select statement for MySQL Connection Failed

[#1]

Hi,

I'm trying to connect to MySql in QlikView v11.

I have made the corresponding Data source for mySql using a driver for mysql5.1.driver

In edit script when i try to connect using ODBC I'm able to see my data source. It shows connection successful without a username or password. and on clicking the ok button the connection string appears on the edit script as "ODBC CONNECT TO myDatasource".

Next when I click the select button, I get "QvConnect 11.00 SR1 has encountered a problem and needs to close.  We are sorry for the inconvenience".(PFA)

What do I do? Pls Help!

Regards,

Natasha

[#2]

can u access the MYsql database from outside QV ?

[#3]

Hi Qlik_techie,

Thanks for replying.

Yes, I can access the database from outside QV.

[#4]

so u mean u have the System DSN made which has been successfully tested & u can access the database & its tables from outside & u dnt have any password also ?

[#5]

Ya thats right.

I do have a password for the connection but while in QV, whwn i connect i dont need to provide the password!

I can connect using the password and also without the password. I think the password was confiquered while making the data source.

[#6]

no..........u do need to provide the password.

[#7]

No,

I can connect without the password.(PFA)

I tried the same thing on another comp and its working alright. The connection and select to the same db is working fine!

Unfortunately I cant use that system and need to solve this issue on my comp.