Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 BCP Error

Author  Topic 

jung1975
Aged Yak Warrior

503 Posts

Posted - 2003-01-11 : 11:18:39
I am trying to save sales table as text file by using BCP,

C:\>bcp pubs..sales out c:\temp\sales.txt -c -T -S(local)

But, I keep getting error message :

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 have a Insert permission on this table...

Thank you for your help

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2003-01-12 : 14:56:10
Can you log on with the credentials you're using here through QA or EM?

Jonathan
{0}
Go to Top of Page
   

- Advertisement -