Hosted DB & LabVIEW

[maxout]

Hi, 

I am looking for a toolkit which would allow to connect and modify the hosted db from LV application. 

What are the options? (excluding the Database Connectivity Toolkit). 

max

[Rolf Kalbermatter]

First check that your host provider does allow external connections to the database server. Almost every webspace provider nowadays lets you choose to install mySQL, (usually as MariaDB now) in your webspace environment so you can implement webstores, blogs and what else on your hosted website. However most do not allow connections to that database from outside the virtual website environment for security reasons.

Once you determined that such external connections are allowed you have to determine which type of database server is used. Besides mySQL (MariaDB), you can also get hosted database servers based on MS-SQL or possibly even Oracle, for some high throughput commercial services, and that will largely influence the possible selection of your interfacing strategy. The SQL Toolkit you so profoundly excluded would support almost all possible servers. Alternatives are LabSQL, which is based on the same ADO interface that the SQL Toolkit uses, or the ADO-Tool.

Depending on the used server you might also get lucky with the mySQL native driver from Saphir.