SQL database

[J]

Hi,
I'm trying to write a simple labview program that accesses and
extracts some information from a SQL database. Can anyone give me
some pointers? Thanks in advance!

~Julie

[Majicz]

"Hello,

"You need the ODBC driver on your computer, then you need a labvew sql toolkit"

1) "Create a Data Source Name as "jacz" for this database in ODBC Administrator with/without password "

2) Try the example with various command set that can be used with the datbase software(which i am sending is for MS Access)

If you have any problem, Pl. let me know
Have a great day.
Regards~
mathews.j@consultant.com

[Dennis_Knutson]

Mathews example uses the old SQL Toolkit from NI. I don't believe this is sold anymore. It has been replaced with the Database Connectivity Toolkit. It comes with a bunch of examples and is pretty simple to use but it is not cheap. If you're familiar with SQL and comfortable with writing your own queries, there is the open source set of VIs from Jeffrey Travis called LabSQL. Both the NI toolkit and LabSQL use ADO to communicate with a database.