Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Too many connections opened creates a failure
Message
De
15/12/2011 14:08:39
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Titre:
Too many connections opened creates a failure
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01531136
Message ID:
01531136
Vues:
75
I have something like this:
Dim loConnection As IDbConnection = Nothing

loConnection = New OleDbConnection(oConnectionOpenManually.cConnectionString)
loConnection.Open()
If I call this code in sequence such as 40 to 100 times in a row within about 1 to 2 seconds, the Open() will fail at one point or another. It seems the SQL Server connection pooling chokes if there are too many calls to it. The error is "Unspecified error". This doesn't help that much. Would there be something I can do to avoid this type of situation when I have to create a new connection in such a sequence?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform