Click here to Skip to main content
15,898,035 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: pbm in richtext box Pin
balakpn8-Mar-07 17:19
balakpn8-Mar-07 17:19 
GeneralRe: pbm in richtext box Pin
Dave Kreskowiak9-Mar-07 4:54
mveDave Kreskowiak9-Mar-07 4:54 
Questionconnection not getting closed Pin
balakpn7-Mar-07 23:38
balakpn7-Mar-07 23:38 
AnswerRe: connection not getting closed Pin
Colin Angus Mackay8-Mar-07 0:02
Colin Angus Mackay8-Mar-07 0:02 
GeneralRe: connection not getting closed Pin
balakpn8-Mar-07 3:47
balakpn8-Mar-07 3:47 
GeneralRe: connection not getting closed Pin
Dave Kreskowiak8-Mar-07 4:27
mveDave Kreskowiak8-Mar-07 4:27 
GeneralRe: connection not getting closed Pin
balakpn8-Mar-07 17:22
balakpn8-Mar-07 17:22 
AnswerRe: connection not getting closed Pin
Daytona_6758-Mar-07 17:23
Daytona_6758-Mar-07 17:23 
I had a similiar issue a while back - I'd be updating thousands of records at a time, but eventually ran into problems with time out errors with SQL. I thought I'd done everything right (followed Microsoft Best Practices)

But the problem was not really with wondering how to forcefully close a connection (my first guess) or to disable connection pooling, it was with how I created the connection in the first place and my management of that connection for the lifetime of the application.

If you've got code that constantly opens and closes a connection to the exact same datasource, I'd maybe rethink that code and only open it once and close it once (with capability to reopen if the connection is lost). I've found that even with connection pooling working and all, when you open a connection more than once, more than one connection is created to the data source.
GeneralRe: connection not getting closed Pin
balakpn8-Mar-07 18:02
balakpn8-Mar-07 18:02 
GeneralRe: connection not getting closed Pin
Daytona_6759-Mar-07 10:23
Daytona_6759-Mar-07 10:23 
QuestionSystem Date Pin
JonCox7-Mar-07 23:36
JonCox7-Mar-07 23:36 
AnswerRe: System Date Pin
andyharman8-Mar-07 2:40
professionalandyharman8-Mar-07 2:40 
AnswerRe: System Date Pin
The ANZAC8-Mar-07 9:41
The ANZAC8-Mar-07 9:41 
AnswerRe: System Date Pin
Member 38798818-Mar-07 17:59
Member 38798818-Mar-07 17:59 
GeneralRe: System Date Pin
JonCox9-Mar-07 8:48
JonCox9-Mar-07 8:48 
QuestionStructuere with WithEvents members Pin
Marc Soleda7-Mar-07 22:48
Marc Soleda7-Mar-07 22:48 
AnswerRe: Structuere with WithEvents members [modified] Pin
TwoFaced7-Mar-07 23:15
TwoFaced7-Mar-07 23:15 
QuestionHow can I draw a line in designer? Pin
NanaAM7-Mar-07 22:37
NanaAM7-Mar-07 22:37 
AnswerRe: How can I draw a line in designer? Pin
TwoFaced7-Mar-07 23:29
TwoFaced7-Mar-07 23:29 
GeneralRe: How can I draw a line in designer? Pin
NanaAM8-Mar-07 1:37
NanaAM8-Mar-07 1:37 
QuestionMenu bars based on users............. Pin
Member 38798817-Mar-07 22:11
Member 38798817-Mar-07 22:11 
AnswerRe: Menu bars based on users............. Pin
haggenx8-Mar-07 8:25
haggenx8-Mar-07 8:25 
GeneralRe: Menu bars based on users............. Pin
Member 38798818-Mar-07 17:13
Member 38798818-Mar-07 17:13 
AnswerRe: Menu bars based on users............. Pin
Jelle Stokroos8-Mar-07 10:15
Jelle Stokroos8-Mar-07 10:15 
GeneralRe: Menu bars based on users............. Pin
Member 38798818-Mar-07 17:07
Member 38798818-Mar-07 17:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.