LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple DB tools insert data Error Code: -2147217900

Solved!
Go to solution

 Hi All 🙂 ,

 

I'm new to LabView. Right now I'm using version 8.2.

I have browse the topic but i dont seem to find what i need.

I have two question and I hope you guyz can help.

 

1. I am doing a program and i need to insert my data in SQL.

Previously, I have done this using single DB Tools Insert Data.vi  due to only one table involved. It was OK.

For this case, I need to push about 8 clusters of data inside database every 5 seconds.

I'm not sure on how i should wired the vi's if i'm using 8 at once.

I have tried connecting it parallelly from the open connection tools and serially from one insert data tools to another.

Is this the correct way to do it? Please advise. I have attached the insert data part of my program.

 

2. Previously when i try to connect all 8 in serial, the vi runs, however, it doesnt pass the data to the database.But when i stopped the VI and tried to run again, the error code -2147217900 come up. Can someone advise on the reasons why it occured?

 

Please advise and million of thanx in advance.

 

regards,

 

 

Roziela Sharib

0 Kudos
Message 1 of 4
(3,562 Views)
Solution
Accepted by topic author Aleizor

study the links here and post if still problem persists

 

Mathan

0 Kudos
Message 2 of 4
(3,553 Views)

Thank you. :smileywink:

 

regards,

 

Roziela Sharib


0 Kudos
Message 3 of 4
(3,545 Views)
Glad to help Smiley Happy
0 Kudos
Message 4 of 4
(3,530 Views)