Connecting desktop labview app to SQL server

[optobionics]

I want to create a desktop application that will connect to a mysql database running on a linux server over our company's intranet. The only database I know how to connect to is ms access through file DSN and only if the app is on the same desktop as my database.

[Herbert Engels]

You can use a WINDOWS dialog for that by calling it via ActiveX. The connection string created by this VI can be wired to the VI that establishes the database connection. You don't need a DSN unless you need some app that only supports ODBC to access your database.

[Crystal]

mySQL only has an ODBC driver, so you can't just use the dialog that Herbert describes. First you configure a DSN through the Control Panel>>Administrative Tools>>Data Sources (ODBC). The settings for the DSN will be different for mySQL than for Access, but they are all there. In fact, the mySQL ODBC driver I use has a button where you can test the connection. So definitely make sure htat works before you try to do anything in LabVIEW. Once you've correctly set up the DSN, you can either use it directly like you did for Access or you can use the dialog described by Herbert.

[Jeremy_L]

In addition, there is a Database Connectivity Toolset available for LabVIEW that you can purchase. It allows you to make SQL commands which should also simplify the application portion of your project.

Jeremy L.
National Instruments

[optobionics]

Thank you very much ... once i installed the mySQL ODBC driver ... i figured it out ... thank you again.