control the connection to database using vb-dll or vb-exe

[manuwa]

Hi,
i would like to open a database-connection with an dll or exe.the db is at the server and the dll's or exe's are on clients. the point is, that i want to control the amount of connections. if another is already open, i would like to know that , before connecting to the database.
another idea: how can i lock in vb, to open a dll or exe again.

please, give me an idea as solution.
with regards,
manuela waldhoff

 

[mohmehran]

If you are using the SQL Server, there is a stored procedures that tells you the number of concurrent connections.

Also you can implement your own method by keeping the count in a storage like db, and increment/decrement it yourself. Mohammad Mehran Nikoo, MCSD mohmehran@msn.com

 

[manuwa]

hi nikoo,
(is the name correct?)
i don't want to count the conntections to the db, but the opened dll's. is it possible to know: if one dll is open, it look's if the same dll is already opened.
thank you,
regards
manuela