labsql and ado

[jespercronborn]

Hello, i'm a new user to both Labview but especially ADO. I want to write data from labview to a MySQL database and server installed on the same computer as labview. Preferably i want to input data immediately in tables from labview. I have read a some about ADO and labsql but i'm very confused. I would appreciate it very much if someone could write all the programs that i need to download and install to do what i described (ADO or ADO.net, OLE DB, JET, ASP, OLE DB consumer). I already have: 

Labview 2013

LABSQL

A MySQL server and Database installed, with workbench

Established an OBDC connection from my computer to this database

If anyone could link me some step by step tutorials for establishing the ADO and labview link (with connectionstring etc), If there aren't any, could you just sum up the steps really basically , i can barely describe how much i would appreciate that! 

Thank you very much in advance for your help, any tips are very welcome! 

[Dennis_Knutson]

There are a couple of examples that come with the toolkit. For queries, you should do a search for SQL tutorials.

[jespercronborn]

The SQL commands part is not a problem. I have seen the examples but i have no idea what to do with them.. What programs do i need to create a connectionstring that i can use? ADO, OLEDB? 

[Dennis_Knutson]

I would typically create a UDL file. This is a right click option in Windows explorer. It's just a text file so you can open it and view the connection string.

[jespercronborn]

In the LABSQL example a connectionstring is all you need to establish a connection though? I don't really understand what you mean, i just need to find out my computers connectionstring then all the work is done? 

[Dennis_Knutson]

I don't have LabSQL installed right now, but yes, a.connection string is all that you need.

[aputman]

Create a new txt file on your desktop and rename it with a .udl extension.  Double click on the file to configure the connection.  After it is tested and confirmed working, open the udl file with a text editor and it will give you a connection string.

[aputman]

You will have to install MySQL Connector for ODBC.

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

[jespercronborn]

Thank you so much for your help so far! I have done as you said, i created a udl file that works, and i can get a connectionstring by selecting an OLE DB provider for OBDC drivers, but if i select a provider for a sql server, i can't find my installed MySQL server on my local computer. Do i need to select the sql server choice, and in that case what do i need to do in order for my mySQL (community server) to be recocgnized? 

[jespercronborn]

Thank you so much for your help so far! I have done as you said, i created a udl file that works, and i can get a connectionstring by selecting an OLE DB provider for OBDC drivers, but if i select a provider for a sql server, i can't find my installed MySQL server on my local computer. Do i need to select the sql server choice, and in that case what do i need to do in order for my mySQL (community server) to be recocgnized?