Limiting the Concurrent Users

Dhruva

Member
Joined
Sep 23, 2004
Messages
12
Programming Experience
Beginner
Hi,

We are planning to Develop an desktop application on VB.NET that will have ODBC connectivity to DB2 Server residing on Mainframe (Version 7).

Now the Question is even now the VB.NET product would be loaded on more than 50 Desktop's we want only 20 Concurrent users can hit the Database, And if 21st one is trying to hit the database they should get the message saying the Database is busy try later.

Can this be implemented from the DB2 Side, while establising the ODBC connection. Is there any option to limit the Number of resources ?
If this is not possible, Can we do this through VB.net and If yes, what is the way for this ?

Any suggestions on this would be highly welcome.
Thanks
Dhruva.
 

suddenelfilio

Well-known member
Joined
Jun 3, 2004
Messages
144
Location
Belgium
Programming Experience
5-10
you could use a webservice or remoting where the application connects to for requesting the connection string. This service will keep track of the numbers of request for the connectionstring, when the limit is reached the service will return database full or something like that
 
Top Bottom