i have to read/update/insert/delete many tables and they all need to get rolled back if they fail. I'm probably modifing 10+ tables in some way....
Good point. is was not destroying the PostTrx.dll object. that is the object that does all the SQL work. i will add that. Thanks
I'm using several cmd objects to read/update/insert/delete from various tables. all are wrapped in the same transaction and rolled back or committed...
comes back with a "0". the 2nd connection doesn't fail when i try to connect, it happens deeper when attempting to read or update but not always at...
No the database is not single-user access. it's part of a large system that allows multi-use, this app is a add in to the database. I'm testing in...
Not sure i can trap because the error seems to change depending on where they collide. Sometimes is SqlCommand is busy fetching other times its...
We are not using MSDE
Thanks for the idea but it did not help. It appears the the connections between the 2 instances of the DLL "know" about each other and block each...
We have a desktop application that called a WebService. The WebService takes the data passed to it from the desktop app and pass this data to...
Separate names with a comma.
