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

Does SQL Server consider it as a trusted connection? If you're using a Windows account, then the two servers need to be in the same domain. Otherwise, you're better off using a username (-U) and password (-P).
Christopher Reed
"The oxen are slow, but the earth is patient."
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform