04-28-2020 03:29 PM
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?
Solved! Go to Solution.
04-28-2020 04:08 PM
BTW using Microsoft SQL for the database.
04-28-2020 05:31 PM
A "good" data base will handle that for you. You will want to have good error handling in your program.
04-28-2020 06:55 PM
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.
06-26-2020 12:17 AM
By the way, DB tools kit,is only for sql server ?
For mysql, which tools we should use ?
Thanks.