RE: ActiveX Data Objects to SQL Databse...

[Puneet_K]

Hiii All,

I need literature on ActiveX Data Objects and SQL Database connectivity with reference to LabVIEW software.In my program i want to use SQL, So i need full decriptive literature by which i can easily understand  how to write program for the same on LabVIEW.

Regards

Puneet

[tst]

Most ODBC interfaces written for LabVIEW use ADO. NI sells a DB toolkit, which you can find by searching the site.

If you search online you can find a free toolkit called LabSQL and if you search the LAVA forums, you should find an ADO toolkit and a set of VIs which use an external DLL and which should be platform indepedent.

If you don't know SQL, there are many tutorials available online through a simple Google search.

[mikeporter]

The best source for data on ADO is Microsoft. Their online documentation is excellent. Go to the Microsoft website and do a search for MDAC. For more info on the process in general, checkout this thread.

Mike...

[mikeporter]

Oops... Didn't notice I had already replied... Duh...

Mike...


Message Edited by mikeporter on 01-03-2008 10:52 PM

[smercurio_fc]

If you haven't already done so, you should take a look at LabSQL, which provides a few packaged VIs for communicating with databases. Still need to know what you're doing with database, though.

[Puneet_K]

Thanks to all,

i got the solution.