LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

DB tool kit, multiple computers opening and closing connections

Solved!
Go to solution
Highlighted

Silly question, but I'm paranoid and unable to test this while working from home. Multiple computers running the same program. Is there going to be an issue/race condition problems with the DB open connections and close connections running at the same time? 

0 Kudos
Message 1 of 5
(353 Views)
Highlighted

BTW using Microsoft SQL for the database.

0 Kudos
Message 2 of 5
(330 Views)
Highlighted

A "good" data base will handle that for you. You will want to have good error handling in your program.

0 Kudos
Message 3 of 5
(311 Views)
Highlighted
Solution
Accepted by topic author breezy45

This is generally only an issue with a file based database like MS Access or SQLite.  I haven't actually done this, so I can't comment directly, but theoretically server-based databases like MS SQL should handle concurrent connections with no problem.

0 Kudos
Message 4 of 5
(300 Views)
Highlighted

By the way, DB tools kit,is only for sql server ?

For mysql, which tools we should use ?

Thanks.

Keep moving
0 Kudos
Message 5 of 5
(159 Views)