Hi,
I am trying to use xp_cmdshell, which I have used on th ejob all the time in this way, but for some reason is not working on my computer. Below is the error mesage that I am getting, but I am not understanding what it is telling me or what to do about it. I
am using SQL Server Express 2008, and my machine is Windows 64 bit processing, is case this has something to do with it. I have enabled TCPIP and Pipes.
If you have any ideas what I can do to get this work I would appreaciate it.
Thank you
SQLState = 08001, NativeError = 126
Error = [Microsoft][SQL Native Client]VIA Provider: The specified module could not be found.
NULL
SQLState = 08001, NativeError = 126
Error = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connecti
ons.
SQLState = S1T00, NativeError = 0
Error = [Microsoft][SQL Native Client]Login timeout expired
NULLMy code:
my code:
This is using the the Northwind database
exec Master..xp_cmdshell 'bcp " Select * from dbo.Employees " queryout C:\TestEd.xls -T -c'
View Complete Post