16.02.2015, 21:57
Multiple connections usually aren't necessary, but when you do use them you must pay extreme attention to include the correct connectionHandle in every function at all times otherwise you'll likely get weird screwups.
I am also not entirely sure if you need to set the option at all if different databases are concerned. I do use this option, but I connect to the same database, albeit with a different user every time. Makes auditing easier. Each active script has its own user with its own specific rights as to what tables it can access.
I am also not entirely sure if you need to set the option at all if different databases are concerned. I do use this option, but I connect to the same database, albeit with a different user every time. Makes auditing easier. Each active script has its own user with its own specific rights as to what tables it can access.