Connection Pooling Issues

  • Thread starter Thread starter Ed Crowley
  • Start date Start date
E

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.
 
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.
__________________________________
 
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.
 
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.
__________________________________
 
Back
Top