VB6 + ADO + General Network Error

rocky050371
rocky050371 used Ask the Experts™
on
I have checked a clients error log and found the following errors on different days, there are others of the same type

05/04/2007 14:28:38 : DB ERROR : Error = 3709 The connection cannot be used to perform this operation. It is either closed or invalid in this context. SQL = [SELECT LogoFilename FROM Company WHERE Branch = 'All Branches']
05/04/2007 14:28:38 : ADO ERROR : Error = -2147467259 [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. : SQL State -> 08S01 : Native error - > 11

11/04/2007 11:12:39 : DB ERROR : Error = -2147467259 [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation. SQL = [SELECT * FROM Additional WHERE Reference = 386]
11/04/2007 11:12:40 : ADO ERROR : Error = -2147467259 [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation. : SQL State -> 08001 : Native error - > 11


Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Is this database local?  Are there any events on the machine with the database showing the database service stopped? or went into recovery mode?  or had errors?  It looks to me like you should focus more on the database (or possibly the network if it remotely located) than the application.
Senior .Net Consultant
Top Expert 2016
Commented:

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial