How Can I send data acquired by a LabView program directly to Database like DB2,Access, Oracle?

[AME]

I have so far stored data collected with LabView Program in Text delimited file, I also want to convert or export my data to db2,access and oracle. How can I do this with LabView, I have an add on SQL kit also.-Arvind

[Dennis_Knutson]

If you've got the old SQL Toolkit, you've got everything you need even if it's not the latest. Your add-on has been replaced with the Database Connectivity Toolkit but the old functions still work. They just don't use the latest database technology and require a bit more knowledge of the SQL progamming language. There was a user manual that came with the add-on and several examples. Put simply, you first create a Data Source Name to the database using the Windows utility ODBC Data Source Administrator. Then using functions in the toolkit, connect to the db, execute a SQL query to insert or retrieve data, and then close down the connection.

Have you tried using the toolkit and have a specifi
c question in regards to it?

[AME]

I have never tried to use toolkit, can you give me some examples related to my question?Thanks

[Dennis_Knutson]

There are numerous shipping examples of using the toolkit. Look in LabVIEW\Examples\SQL. To start, look in General.llb for SQL Toolkit Demo. There's a subVI called Demo - Populate Demo Table that shows how to use the Insert command to create new records.

[Jim_Cavera]

As Dennis said, the SQL Toolkit is probably the way to go. Note however, that if you are gathering data at high speed (hundreds of points per second over multiple channels), then the data can't be sent to the DB in real time.

For this sort of thing, you will need to store the data in either a buffer or an external file and dump it to the database when done with the acquisition.

- Jim