Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-25 : 09:28:04
|
| Shantanu writes "I have gone through the Data Access Strategy published in MSDN. It does answer some questions but leaves some unanswered. I would appreciate if you could answer the following ASAP:1. What is the recommended database connection pooling strategy for SQL Server 2000 on a .NET platform? The SQL Server 2000 would be installed on Advanced Windows Server 2000.2. What is the recommended exception handling mechanism for SQL Server 2000? Can the end user plug-in his/her own module for the same?RegardsShantanu" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-07-25 : 10:18:37
|
1. Depends2. DependsBut a rough answer1. I am not 100% sure on the .NET part yet (someone will jump in here  ) but in "classic" asp and ADO, if you release connections early Win2k will handle pooling for you.2. Yes you can create your own error handling, or ASP.NET will let you specify an error page to redirect to. I am assuming ASP.NET as you didn't specify.Damian |
 |
|
|
|
|
|
Data Access Strategy