-2147467259 Unspecified Error

From: Terry (anonymous_at_discussions.microsoft.com)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 11:46:06 -0700

-2147467259 Unspecified Error. That's what I get when opening an ADO connection in VB6. The open works fine in production scenerio for many weeks and then out of nowhere, I get this error. It happens about every 2-3 weeks. I restart VB application and it will run for another period of time. I'm suspicious that the ADO has lost contact with the database in a way that it cannot recover. I don't think I have any control over this, but I can trap for this. But once trapped, I cannot fix it wihtou killing .exe and starting it again. Is there a way to restart/kick the ADO for the .exe without having to bring down the entire .exe? Any other ideas or approaches welcome!

Thanks,
Terry