Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > ADO Data > VB6 Async conne...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 4242 of 4320
Post > Topic >>

VB6 Async connection locks up closing connection

by =?Utf-8?B?RWxlbmE=?= <Elena@[EMAIL PROTECTED] > Jun 3, 2008 at 01:24 PM

I have a VB6 app using a SQL Server 2005 Express database as an event
logger. 
 The database is on the same PC as the app.  The app opens an Async 
connection to the database and does a SQL INSERT to write an event to the 
database 1 to 3 times a second.  On the ExecuteComplete event, it closes
the 
connection.

After a few days of continuous operation, the app freezes with 50% CPU 
usage, which is actually 100% of one core in a dual-core PC.  I attached 
WinDbg to the process, and it appears that the app is stuck in the 
ExecuteComplete event where it is calling the CloseConnection method of
the 
ADODB.Connection object.  Inside CloseConnection, it seems to be in a loop

calling MSDART!CReaderWRiterLock3::IsWriteLocked.

Any ideas on what is causing this or how to troubleshoot it further?

Thanks.
 




 6 Posts in Topic:
VB6 Async connection locks up closing connection
=?Utf-8?B?RWxlbmE=?= <  2008-06-03 13:24:01 
Re: VB6 Async connection locks up closing connection
"Bob Barrows [MVP]&q  2008-06-03 16:59:04 
Re: VB6 Async connection locks up closing connection
=?Utf-8?B?RWxlbmE=?= <  2008-06-03 14:21:01 
Re: VB6 Async connection locks up closing connection
"Bob Barrows [MVP]&q  2008-06-03 18:02:23 
Re: VB6 Async connection locks up closing connection
"Razvan Socol"   2008-06-03 22:18:39 
Re: VB6 Async connection locks up closing connection
=?Utf-8?B?RWxlbmE=?= <  2008-06-04 06:08:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 13:57:34 CST 2008.