topic Re: Select statement for MySQL Connection Failed in QlikView https://community.qlik.com/t5/QlikView/Select-statement-for-MySQL-Connection-Failed/m-p/387860#M144712 <HTML><HEAD></HEAD><BODY><P>Hi Qlik_techie, </P><P></P><P></P><P>Thanks for replying.</P><P>Yes, I can access the database from outside QV.</P></BODY></HTML> Wed, 31 Oct 2012 10:39:34 GMT 2012-10-31T10:39:34Z Select statement for MySQL Connection Failed https://community.qlik.com/t5/QlikView/Select-statement-for-MySQL-Connection-Failed/m-p/387858#M144710 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to connect to MySql in QlikView v11.</P><P>I have made the corresponding Data source for mySql using a driver for mysql5.1.driver</P><P>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".</P><P>Next when I click the select button, I get "QvConnect 11.00 SR1 has encountered a problem and needs to close.&nbsp; We are sorry for the inconvenience".(PFA)</P><P>What do I do? Pls Help!</P><P></P><P>Regards,</P><P>Natasha</P></BODY></HTML> Wed, 31 Oct 2012 10:25:46 GMT https://community.qlik.com/t5/QlikView/Select-statement-for-MySQL-Connection-Failed/m-p/387858#M144710 2012-10-31T10:25:46Z Re: Select statement for MySQL Connection Failed https://community.qlik.com/t5/QlikView/Select-statement-for-MySQL-Connection-Failed/m-p/387859#M144711 <HTML><HEAD></HEAD><BODY><P>can u access the MYsql database from outside QV ?</P></BODY></HTML> Wed, 31 Oct 2012 10:28:00 GMT https://community.qlik.com/t5/QlikView/Select-statement-for-MySQL-Connection-Failed/m-p/387859#M144711 2012-10-31T10:28:00Z Re: Select statement for MySQL Connection Failed https://community.qlik.com/t5/QlikView/Select-statement-for-MySQL-Connection-Failed/m-p/387860#M144712 <HTML><HEAD></HEAD><BODY><P>Hi Qlik_techie, </P><P></P><P></P><P>Thanks for replying.</P><P>Yes, I can access the database from outside QV.</P></BODY></HTML> Wed, 31 Oct 2012 10:39:34 GMT https://community.qlik.com/t5/QlikView/Select-statement-for-MySQL-Connection-Failed/m-p/387860#M144712 2012-10-31T10:39:34Z Re: Select statement for MySQL Connection Failed https://community.qlik.com/t5/QlikView/Select-statement-for-MySQL-Connection-Failed/m-p/387861#M144713 <HTML><HEAD></HEAD><BODY><P>so u mean u have the System DSN made which has been successfully tested &amp; u can access the database &amp; its tables from outside &amp; u dnt have any password also ?</P></BODY></HTML> Wed, 31 Oct 2012 10:46:40 GMT https://community.qlik.com/t5/QlikView/Select-statement-for-MySQL-Connection-Failed/m-p/387861#M144713 2012-10-31T10:46:40Z Re: Select statement for MySQL Connection Failed https://community.qlik.com/t5/QlikView/Select-statement-for-MySQL-Connection-Failed/m-p/387862#M144714 <HTML><HEAD></HEAD><BODY><P>Ya thats right.</P><P>I do have a password for the connection but while in QV, whwn i connect i dont need to provide the password!</P><P>I can connect using the password and also without the password. I think the password was confiquered while making the data source.</P></BODY></HTML> Wed, 31 Oct 2012 10:55:13 GMT https://community.qlik.com/t5/QlikView/Select-statement-for-MySQL-Connection-Failed/m-p/387862#M144714 2012-10-31T10:55:13Z Re: Select statement for MySQL Connection Failed https://community.qlik.com/t5/QlikView/Select-statement-for-MySQL-Connection-Failed/m-p/387863#M144715 <HTML><HEAD></HEAD><BODY><P>no..........u do need to provide the password.</P></BODY></HTML> Wed, 31 Oct 2012 11:05:19 GMT https://community.qlik.com/t5/QlikView/Select-statement-for-MySQL-Connection-Failed/m-p/387863#M144715 2012-10-31T11:05:19Z Re: Select statement for MySQL Connection Failed https://community.qlik.com/t5/QlikView/Select-statement-for-MySQL-Connection-Failed/m-p/387864#M144716 <HTML><HEAD></HEAD><BODY><P>No,</P><P>I can connect without the password.(PFA)</P><P></P><P>I tried the same thing on another comp and its working alright. The connection and select to the same db is working fine!</P><P>Unfortunately I cant use that system and need to solve this issue on my comp.</P><P><IMG __jive_id="24451" class="jive-image-thumbnail jive-image" onclick="" alt="noPWD.bmp" src="https://community.qlik.com/legacyfs/online/24451_noPWD.bmp" width="450" /></P></BODY></HTML> Wed, 31 Oct 2012 11:48:02 GMT https://community.qlik.com/t5/QlikView/Select-statement-for-MySQL-Connection-Failed/m-p/387864#M144716 2012-10-31T11:48:02Z