Question

SQLState = 08001, NativeError = 17 Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server

在sql server里面，执行这句话报错
EXEC master..xp_cmdshell 'bcp "SELECT au_id ,au_lname from pubs..authors" queryout "c:\temp1.xls" -c -Swufy-Usa -P'

报错信息
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server 不存在或拒绝存取。
SQLState = 01000, NativeError = 53
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
NULL

但是执行下面的这句话，就能成功
EXEC master..xp_cmdshell 'bcp pubs..authors out c:\temp1.xls -c -q -Swufy -Usa -P'

Answer 1

自己找到问题了，重新注册一个来回答问题

上面少了一个空格应该
EXEC master..xp_cmdshell 'bcp "SELECT au_id ,au_lname from pubs..authors" queryout "c:\temp1.xls" -c -Swufy -Usa -P'