Im currently writing an application that could potentially have 200+ users obviously being able to do update, insert sql queries to the same database at any given time. I have been reading up on this problem and have been told that using transaction is the way to go? The problem that I have got is 1) finding examples of how to do this and 2) being able to check / set the COM+ service up automatically for my application using code?
I was wondering if anyone has done this and would like to share there knowledge and examples if possible. As I am resonably still new to vb.net this is taking me into a new level, but I want this program to be written properly.
A bit of info on the systems I am running:
vb.net
MSDE (but will be sql server when rolled out)
WinXP and Win2K
Cheers
Simon
I was wondering if anyone has done this and would like to share there knowledge and examples if possible. As I am resonably still new to vb.net this is taking me into a new level, but I want this program to be written properly.
A bit of info on the systems I am running:
vb.net
MSDE (but will be sql server when rolled out)
WinXP and Win2K
Cheers
Simon