How do I connect to a MYSQL Database with connectivity toolkit?

[T-Mac]

I need to connecto to a MYSQL database using labview 7.1 with the database connectivity toolkit.  I am able to connect to a MSSQL database but not a MYSQL database.  What is the procedure to connect to a MYSQL database?

[bdougr]

It shouldn't be any different than the SQL-Server method

you create a .dsn file that points to the mysql database then reference the .dsn file in labview

maybe you need to install the database definition into windows (most likely odbc)

http://dev.mysql.com/downloads/connector/

[HWJ]

Hi I also encounter this problem of being able to connect to MSSQL server but not the MySQL server. I'm sorry for being ignorant. Can someone kindly teach me how to create the .dsn file?  What should I do with the 2 x lib dll files? Thanks.

[HWJ]

hi i managed to find the MySQL connectors and have installed it. However, during the configuration of the ODBC, my local host is not allowed to connect to the SQL server.

FYI, I'm using MySQL version 5.0.17. In the installation of this MySQL, i also encounter connection error 1045: The security settings couldnt be applied to the database due to the access denied for user.

Can anyone advice on the above 2 errors?

Thanks.

[Andy F.]

Hey HWJ!

This sounds like more of a MySQL server question and not LabVIEW and I am not very familiar with MySQL server, however I will try to help out as much as I can.  I did a quick search for the error that you mentioned and it looks like it is pretty common.  Here is a link to a Adobe site that talks about specifically the 1045 error.  That link is about Dreamweaver, but check out the additional links at the bottom.  I think those might be helpful for you.  

Hope this helps!

Andy F.