Error inserting data with DB connectivity toolkit

[anderg]

Hello everyone

I´m recording some data in a ORACLE DB. I´m using the attached vi. It works correctly but, sometimes, the server reboots.

After this happens i don´t get any error doing the insert query, but no data is saved in the DB, so i think that must be a reference opened that doesn´t let me save data.

Any idea?

Thanks

[aputman]

If you are doing an INSERT / UPDATE, there is no need to fetch the recordset.  Here is how I would set it up.  Basically the while loop will try to connect 10 times if an error occurs.  After 10 retries, the error message is displayed.  You need to handle the errors, not just wire them thru each VI. 

[anderg]

Ok, thanks, I´m going to try this