Monday, March 12, 2012
need advise on sql error 999 and 10054, only happens when you walk
[Microsoft][ODBC SQL Server Driver]Communication link failure
SQL Error 10054 SQLSTATE=01000
[Microsoft][ODBC SQL Server] [DBNETZIB]ConnectionWrite(Send())
hello,
We are getting the above errors from sql 2000 SP3.
it only happens when people return to their workstations and the screen
saver has turned on.
thank you,
OskarHi Oskar
Go to Control Panel / Power Options and set System Standby to Never.
The screen saver will continue to appear, but the network card should
not be turned off anymore.
Razvan
Wednesday, March 7, 2012
Need a Quick Answer
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||This is the full error string 'Error in from datahost.Prime.cmdlmport_Click: [Microsoft][ODBC Driver Mananger] driver does not support this function. This is an import of data files from one server to our server. This seems to be an unknown error as it happens every night during the import process and it has never happened since our recent upgrade to SQL 2005.|||Did you try the new ODBC Driver from the SNAC drivers ? After installing the SQL Native Client you will have to change your connecting string a bit to make the application to use the new ODBC libraries. Connectionstring examples can be found on the www.connectionstrings.com site.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de