DB tool kit, multiple computers opening and closing connections

[breezy45]

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? 

[breezy45]

BTW using Microsoft SQL for the database.

[Frozen]

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

[mdwebster · Accepted solution]

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.

[Brzhou123]

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

For mysql, which tools we should use ?

Thanks.