MS SQL Server ODBC - General SQL error

Author

General SQL error

Vincent Schmid

2005-08-02, 9:23 am

Hello,

We have a client application which runs on about 15 workstations
(Windows XP). This application connects to a SQLServer 2000 database
held on a Windows 2003 server.

The connection is done through ODBC.

We have this problem on two client workstations : Whenever the user
leaves the machine unattended for a long time (like lunchtime) and come
back, the client cannot connect to the database. This is the message we
have :

General SQL error.
[Microsoft][ODBC SQL Server Driver]& #91;DBNETLIB]Connect
ionWrite (send()).
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Erreur réseau générale.
Consultez la documentation relative à votre réseau

We had this error previously with an old 10baseT network. The network
has been entirely replaced by a new 100MBits cabling now, and we still
have the same problem on the two same machines. So the cabling is
probably not the cause here.

Any hint welcome,
Best regards,
Vincent

Matt Neerincx [MS]

2005-08-22, 3:23 am

ConnectionWrite (send()) means that the driver had a failure calling the
tcp-ip API send. Hence this points to network problems.

One thing you could try is running cliconfg.exe tool (Start|Run -> cliconfg)
and configuring named pipes as the primary default protocol (instead of
tcp-ip), this may alleviate the problem. Use the up and down arrows to move
named pipes to the top of the list.

Matt Neerincx [MSFT]

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

Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Vincent Schmid" <nospam.forme@nowhere.com> wrote in message
news:42ef752c$0$1162
$5402220f@news.sunrise.ch...
>
> Hello,
>
> We have a client application which runs on about 15 workstations (Windows
> XP). This application connects to a SQLServer 2000 database held on a
> Windows 2003 server.
>
> The connection is done through ODBC.
>
> We have this problem on two client workstations : Whenever the user leaves
> the machine unattended for a long time (like lunchtime) and come back, the
> client cannot connect to the database. This is the message we have :
>
> General SQL error.
> [Microsoft][ODBC SQL Server Driver]& #91;DBNETLIB]Connect
ionWrite (send()).
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]Erreur réseau générale.
> Consultez la documentation relative à votre réseau
>
> We had this error previously with an old 10baseT network. The network has
> been entirely replaced by a new 100MBits cabling now, and we still have
> the same problem on the two same machines. So the cabling is probably not
> the cause here.
>
>
>
> Any hint welcome,
> Best regards,
> Vincent

Vincent Schmid

2005-08-25, 3:28 am

Matt Neerincx [MS] a écrit :
> ConnectionWrite (send()) means that the driver had a failure calling the
> tcp-ip API send. Hence this points to network problems.
>
> One thing you could try is running cliconfg.exe tool (Start|Run -> cliconfg)
> and configuring named pipes as the primary default protocol (instead of
> tcp-ip), this may alleviate the problem. Use the up and down arrows to move
> named pipes to the top of the list.
>

Hi Matt,

I did as you suggested and for now it seems that the problem is gone.
Thank you very much for your valuable help !

Sincerely,
Vincent

Sponsored Links