Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BCP
Message
From
27/04/2009 15:56:46
Greg Rowe
Memphis Police Department
Memphis, Tennessee, United States
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
BCP
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01396577
Message ID:
01396577
Views:
130
When I run exec master..xp_cmdshell 'bcp ##temp_text out \\servername\sharename\filename.txt -c' I receive the following error

SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
SQLState = 01000, NativeError = 2
Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

I successfully run the command on another server without any problems or errors. I verified the share's security. I can successfully run exec master..xp_cmdshell 'bcp dir c:\ > \\servername\sharename\filename.txt'
Next
Reply
Map
View

Click here to load this message in the networking platform