Re : MySQL database with SQL Toolkit

[OZI]

Hi,

we are using CVI 2012 and the SQL Toolkit 2.2 and we want to connect to a MySQL database.

The MySQL database was created with MySQLServer. When we try to connect with DBConnect we get an error.

How can we connect the MySQL Database?

What do we have to type in the connection string in DBConnect? Is it the name of the database, the path to the database or anything else?

Does any one have experience with the SQL toolkit?

Thanks in advance

Oliver

[Goncalo · Accepted solution]

You need to install the mysql connector odbc and then create an ODBC dns for your database.

control panel, administrative, odbc

[OZI]

Hi,

thanks for your help we got it to run

thanks

Oliver