Connection Pooling Issues

[Ed Crowley]

Are there any issues with connection pooling in a VB.NET Windows Forms app
and SQL Server security?

I would like to implement pretty much all the security using SQL Server
roles and Windows Authentication. Will I encounter any issues with this?

Thanks for your time.

 

[Ravikanth[MVP]]

Hi

Please look into the following msdn article
http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/cpguide/html/cpconconnectionpoolingforsqlservernetdatap
rovider.asp

HTH
Ravikanth[MVP]

 

[William \(Bill\) Vaughn]

What kind of application are you creating? Windows forms or ASP or
middle-tier components? Each of these manage the pool differently.

See my article on connection pooling in SQL Server magazine. It should help.

http://www.betav.com/sql_server_magazine.htm

--
____________________________________
Bill Vaughn
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Ed Crowley]

I'm creating a Windows Forms application, although I may wish to create a
web front-end at a later date.

Thanks for the link.

 

[Ed Crowley]

Thanks, but this doesn't appear to deal with security related issues.

 

[William \(Bill\) Vaughn]

Ok, in this case you can choose either SSPI (domain-managed) or SQL Server
security security. The connection pool will not play a big role in the
design as you only get one pool per process (per Windows app).

--
____________________________________
Bill Vaughn
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________