Questions on OLEDB connection in webdev app

Hi,

When 20 users using one webdev app concurrently via OLEDB to MS SQL server, are we connecting with 20 db connections or just 1 db connection ?

Regards,

PETER ZHOU

20 if in dynamic mode.
What is the version of the MSSQL, EXPRESS has limitations.



Edited 1 time(s). Last edit at 07/02/2009 01:52PM by Paulo Oliveira.

Quote
Paulo Oliveira
20 if in dynamic mode.
What is the version of the MSSQL, EXPRESS has limitations.
Edited 1 times. Last edit at 07/02/09 01:52PM by Paulo Oliveira.

It's ms sql 2005 but the backend is ms sql server and not the express version.

Sorry, what do you mean by "dynamic mode" ?

What i understand is that an OleDbConnection object represents a unique connection to a data source. In the case of a client/server database system, it is equivalent to a network connection to the server.
So if there's 3 webdev application ( opening 3 connections ) and it has 20 users each, that will be 60 SQL Server connections. Right?

Regards,

PETER ZHOU

If it's dynamic mode (normal webdev mode) the session is open from the beginnig until endprogram or timeout, if it's AWP mode the session starts/ends for every page sent to the browser.
Yes, 60 connections. It's the same as one application with 60 users.

The only important number is the number of sessions, one session for each user/broswer session.