Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oledb connection pooling?
Message
From
07/03/2011 11:19:01
 
 
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
VB 8.0
OS:
Vista
Network:
Windows XP
Database:
Jet/Access Engine
Application:
Desktop
Miscellaneous
Thread ID:
01502760
Message ID:
01502843
Views:
33
>Never really used Access so I'm just guessing, but I don't think JET was ever intended to properly support multiple access (using it as a data store for a web app could get nasty quite quickly :-} ) so, if you are not doing that, one of the primary benefit of connection pooling disappears. But if that takes away one of the upsides of pooling it doesn't mean there is a downside to enabling it.
>Maybe it's just a legacy thing - I've a feeling earlier versions may not have supported pooling so changing the default later would have been dangerous ?
>
>Dunno really........


As good an explanation as any ... ;0)

~~Bonnie
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Reply
Map
View

Click here to load this message in the networking platform