Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2000
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'
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement