Showing posts with label microsoftodbc. Show all posts
Showing posts with label microsoftodbc. Show all posts

Monday, March 12, 2012

need advise on sql error 999 and 10054, only happens when you walk

SQL Error 999 SQLSTATE=08501
[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

Has anyone encountered this error message [Microsoft][ODBC Driver Managr] Driver does not support this function? This occurs when importing data. The company I work for upgraded to Server 2005 and now what once worked fine now has an error. Any suggestions?Which function did you try to use ? It would be interested to know the called function as well as the connection string you are using.

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