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.
| Author |
Topic |
|
smorty44
Yak Posting Veteran
93 Posts |
 Posted - 2007-08-14 : 11:00:27
|
| I'm learning how to use bcp and am trying to work an example using the pubs database. I put this code in the command prompt and am getting this error:CODE:C:\>BCP PUBS.SALES.CURRENCY OUT CURRENCY.DAT -c -U -P -S(AO3\AO3)ERROR:SQLState = 08001, NativeError = 17I'm working on the database server and have tried -S(local) but still receive the same error. What am I doing wrong? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-14 : 11:37:43
|
| you must run this on the computer where the SQL Server is installed. not on the client computer._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-14 : 23:04:13
|
| Tried with this? Is instance name correct? By the way, you can run bco on sql server or sql client machine. BCP PUBS.SALES.CURRENCY OUT CURRENCY.DAT -c -U some_id-P xxx -S AO3\AO3 |
|
|
|
|
|
|
bcp error