Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BCP
Message
De
27/04/2009 15:56:46
Greg Rowe
Memphis Police Department
Memphis, Tennessie, États-Unis
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Titre:
BCP
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01396577
Message ID:
01396577
Vues:
129
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
Fil
Voir

Click here to load this message in the networking platform