LabView-DataBase Connectivity

[Ranjeet_Singh]

Why inside while loop you are checking list of tables? doesnt make any sense.

Can you share the data(2D) array which you are inserting to DB. I will create the VI as per

[Ranjeet_Singh]

PFA, Check this VI

[SKant]

Hi Ranjeet,

I am geting the attached error message in your code.

[SKant]

Hi Ranjeet,

Actually my requirement is storing huge data into the database(SQL2008).

For example, the acquired data is an array with 1024 point, and I got the array ten times every second, and the test run for 5 min. 

I wanted to store all the 5 min data into database in a single go. it should not take more than one minute.

[Ranjeet_Singh]

Are you able to add single record? Why dont you acquire the data continosly and later add to database?

I think you can add all the record in 5 min. Transaction is very fast. 

In my VI number of column in database and no of parameters in record which is being added is mismatching.

[SKant]

In your VI , i have corrected that and make both identical. thereafter also i am getting same error.

Same thing I was tring to do but I am not able to write the array value into DB, whatever I am writing in database Its writing as a some special character like @#$aD#@4. So i used for loop and extract al the array data and writing one into one in database but its taking lots of time to write i.e more than a hour.

I have attached my code and you code for review.

Please let me know if u found something.

Thanks

[Ranjeet_Singh]

If columns are same then you should not receive same error message.

2011 VI please.

Can you share your record.