How do read/write records from a SQL server hosted on the Web?

[mastaflash]

If I have a MS SQL  Server hosted on the internet, how can I use Labview to access it? Examples appreciated.

TIA,

Les 

[RavensFan]

Have you tried searching the forums for SQL?

Or the example finder in LabVIEW?

[Deepu]

See if this thread is useful.

Regards

[jcarmody]

I have a web-hosted MySQL database.  I set up an ODBC data source (Windows) and use a UDL file and am able to connect just as easily as I can an Access database on my PC.

Message Edited by jcarmody on 04-23-2009 09:12 AM

[ctardi]

You can use ODBC, though I have found that it is more convinient to use a connection string...that way you don't have to set up the ODBC connection on every computer you want to use the application on.

You will also have to have your database server set up to allow outside connections, as I beleive ms sql only allows connections from localhost by default.

Not sure if you need specific examples on how to talk to a database, but, as suggested, a search should yeild many results.

Message Edited by ctardi on 04-23-2009 08:44 AM

[mastaflash]

Thanks for that. So am I to understand that the database tools will construct the required http strings the post and retrieve data?

TIA

Les 

[ctardi · Accepted solution]

Yup, just provide the connection string and they query, and the database tools take care of the rest.

[mishkin]

Check out the product page for NI LabVIEW Database Connectivity Toolkit to learn more and feel free to post any additional questions you have.

Edit: The LabVIEW Database Connectivity Toolkit is now only sold as part of LabVIEW Professional.