help!-storing Daq data into access database

[SG_SP_OLED]

Hi,sorry ,need help in storiing Daq data into access database.Previously,I've edited an Example VI and i was able to insert data into access database.I've uploaded the block diagram for my initial diagram.After successful running,I've decided to changed one of its inputs into the DAQ data output whereIm storing some voltage values.However,an error occurs.I was still able to get the Daq voltage(I've inserted an indicator to check for the voltage reading at the front panel),but there's problem inserting it into the database.Can someone enlighten me where did i go wrong?Isit the data type conversion or something else entirely?Thanks alot in advance!=)

[GovBob]

SG,

Your instincts are probably correct. It looks like you are having a data conversion problem. The data coming from the DAQ assistant probably doesn't match the data you are bundling to go into the database. See the red coerce dots on your "data" indicator and your insert into database? This means LabVIEW has changed the data type somehow to properly represent it. This is not always bad but you should try to avoid those. I see that you are converting the dynamic data type to some type of double and then back to DDT. Why? You probably do need to use the From DDT express vi to match the correct data type to what is defined in your database. I can't tell you exactly how to do it as I can't troubleshoot a picture .jpg. and I don't know the structure of your database. Also the DAQ Assistant hides code so I have no idea what kind of data you are collecting.

 Are you using DAQmx? A lot of us avoid using any express vi's as they can hide code and include overhead. They are ok if you want something quick but as you have found out they have drawbacks. If you right click on that DAQ assistant vi you can convert it to code to see how it works and you will not have to use the Dynamic Data Type (DDT) then. Also a great reference is: http://zone.ni.com/devzone/cda/tut/p/id/2835

Hope this helps