32 KS/s data collection and database logging

[ControlAutomation]

I am trying to acquire 5 analog inputs from a CompactDAQ system and log these with timestamps to an SQL database at a rate of 32,000 samples per second.  The acquisition takes place during one second of the cycle and I have almost 2 more seconds to get the data into the database (3 second press cycle).  I am using a 9203 (one point) and a 9305 (four points) module.  What is the simplest method of implementing this?  What Labview tools and/or VI's should be used? Can anyone provide me an example of how to do this?

[mikeporter]

How are you wanting to store the data as a waveform/array (pretty easy) or as individual values (will require divine intervention)? Also, what kind of database?

Mike...

[ControlAutomation]

Waveform is the preferred method as we are trying to capture a tonnage signature from a press.  The DB will end up being SQL, but for the purposes of the trial, I would like to keep it simple since we are running from a laptop.  If Access can handle the speed, this would be the simplist.  I also have SQL Server Express 2005 on the laptop which could be utilized. 

[mikeporter]

Check-out this thread it offers some good discussion of the issues and code for communicating with databases. In terms of what you are wanting to do, if you have access to a full version of SQL Server - or even the free version which is also very good - it would be much better than Jet.

Miked...