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 |
|
kathunter
Starting Member
35 Posts |
 Posted - 2002-01-30 : 20:55:21
|
| I use a client SQL Enterprise to update a table in our romote database. I wanted to use BULK INSERT but it was looking on the servers hard drive and not the client I was on. So I moved to bcp. I tried the following:C:\>bcp "db.dbo.neworders" in "c:\neworders.txt" -U"username" -P"password"I received an error:...SQLState = 08001, NativeError = 6Error = [Microsoft][ONBC SQL Server Driver][Named Pipes] Specified SQL server not found.SQLState = 01000,NativeError = 2Warning = [Microsoft][ONBC SQL Server Driver][Named Pipes]ConnectionOpen (Create File())...What does this mean?I should have taken the blue pill |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-01-30 : 22:02:00
|
| You didn't specify the server name using the -S parameter on the bcp call. I don't remember if it defaults to (local) or not, but you can't go wrong with explicitly putting the server name on the command line. |
 |
|
|
|
|
|
BCP error?