Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Too many connections opened creates a failure
Message
From
15/12/2011 14:29:33
Viv Phillips
Hay-On-Wye, United Kingdom
 
 
To
15/12/2011 14:15:12
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
General information
Forum:
ASP.NET
Category:
Other
Title:
Re: Too many connections opened creates a failure
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01531136
Message ID:
01531143
Views:
52
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......
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform