Connect to a remote web hosted site and mySQL with LabVIEW

[paljacob]

I must be missing something, but I'm not able to connect to my public site's mySQL database. It is simple in php, but I'm not able to do the same in Labview for some reason.

The site is hosted by one.com. I want to make an executable that ask the database for some settings and post user stats. Is this possible/really hard? Do I need to make a 

Here is the mysql info i got from one.com:

MySQL info:
Host:	sitename.com.mysql
Database:	sitename_com
Brukernavn (User):	sitename_com

Passord (Password):

*********

I have the Database Connectivity Toolkit and tried alot off different things. Do I really need to create a DSN? If so, I guess this must be included in the installer and I guess I will try to find another method for doing this.

In php, I need to add one.com after the host name., there I do not need to set the port name, but does this meen it uses the default one 1433?

Pål Jacob

[aputman]

Use connection strings:

You have to change the ODBC driver name to match the one you have installed.

[paljacob]

Thanks aputman and sorry for the late reply! 

So it is possible to just link a string into the connection information 🙂

Do you know it is easy to add ODBC installation into an installer created with LabVIEW. The application will for now only run on Windows 32bit and 64bit, so that may be possible to support?

[aputman]

I haven't built installers but i believe it is possible to add third-party installers to a build.