Limiting the Concurrent Users

[Dhruva]

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]

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