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:29:33
Viv Phillips
Hay-On-Wye, Royaume Uni
 
 
À
15/12/2011 14:15:12
Michel Fournier
Level Extreme Inc.
Petit-Rocher, Nouveau-Brunswick, Canada
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Titre:
Re: 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:
01531143
Vues:
51
This message has been marked as the solution to the initial question of the thread.
>When I worked in manual mode, such as opening the connection everytime, I added some code at the end of my SQLUpdate() method to close the connection. This has resolved the issue.

Since OledbConnection implements IDisposable the simplest and safest way is the wrap the whole thing in a USING.... ENDUSING block......
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform