Shulou(Shulou.com)05/31 Report--

This article is about how sql server imports txt files into the data China Times SQL network interface: what to do if the server does not support it. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Sql server imports txt files into data China Times SQL network interface: the server does not support the requested protocol

1. Sql server imported txt file into data. China Times error

SQLState = 08001, NativeError =-1

Error = [Microsoft] [SQL Native Client] SQL network interface: the server does not support the requested protocol [xFFFFFFFF].

SQLState = HYT00, NativeError = 0

Error = [Microsoft] [SQL Native Client] login timeout has expired

SQLState = 08001, NativeError =-1

Error = [Microsoft] [SQL Native Client] an error occurred while establishing a connection to the server. When connecting to SQL Server 2005, the fact that the default setting of SQL Server does not allow remote connections may result in failure.

The query is caused by the fact that the data source of WINDOW's ODBC is not configured, so the problem of configuring the data source is solved.

The sql statement executed is: EXEC master..xp_cmdshell 'bcp dataBase..tb_txn_nk_temp in [D:\ Program Files\ Apache Software Foundation\ Tomcat 6.0\ webapps\ com.ghl.etsys.ETSYS\ WEB-INF\ TxnData0-01\ alldata20120813-20120813\ data\ 2012-08-13.txt]-c-S localhost-Usa-Prootroot-t,'

DataBase is the name, tb_txn_nk_temp is the table name, sa is the database user name, and rootroot is the password

Thank you for reading! About "sql server imports txt files into data China Times SQL network interface: what to do if the server does not support?" this article ends here. I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.