Very Computer

Hi all,

We have somw workstation,each of them use a VB client
program to input data to SQL2000 database,the client use
ADO to connect to database,it works generally OK,but
occasionally returns "[DBMSSOCN]General network
error",please advise what might the problem cause.

Since other network application doesn't affected at the
same time,we think it is not a network problem.After
restart the client program,everything is OK,but all
inputed data gets lost.Does there anything to do with the
perfomance of SQL database system?

Hi,

To see what could be wrong, try to use SQL Profiler or
Performance Monitor.

Val

Quote:>-----Original Message-----
>Hi all,

>We have somw workstation,each of them use a VB client
>program to input data to SQL2000 database,the client use
>ADO to connect to database,it works generally OK,but
>occasionally returns "[DBMSSOCN]General network
>error",please advise what might the problem cause.

>Since other network application doesn't affected at the
>same time,we think it is not a network problem.After
>restart the client program,everything is OK,but all
>inputed data gets lost.Does there anything to do with the
>perfomance of SQL database system?
>.

It is highly possible that an intermittent and momentary network failure of
some sort is causing this problem; I have also found reference to this
problem being fixed by upgrading to Microsoft Data Access Components 2.6 or
later. You can download this from:

http://www.microsoft.com/data.

MDAC 2.6 is required for proper connectivity to SQL Server 2000. Make sure
your workstations are running this version or later.

Hope this helps.

Steven Bras, MCSD
Microsoft Developer Support/Visual Basic WebData

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.