bulkcopy

[tuzojazz]

Hi guys:

I'm using SQL Server 2000

I'm trying to execute bcp in a DOS window with different syntax

bcp MyBase..dbo.MyTable out c:\Bulktest\test.txt -c -Uuser1 -Ppass1 -SMyServer

bcp MyBase..MyTable out "c:\Bulktest\test.txt" -c -Uuser1 -Ppass1 -SMyServer

bcp MyBase..MyTable out c:\Bulktest\test.txt -c -Uuser1 -Ppass1 -SMyServer


In all of the cases I get the same error :

CTLIB Message: - L6/O8/S5/N3/5/0:
ct_connect(): directory service layer: internal directory control layer error: R
equested server name not found.
Establishing connection failed.



If I ping MyServer it works

so

What is the correct syntax?

Thanks!

 

[gmmastros]

MyBase..dbo.MyTable

Is MyBase a linked server or is it the name of your database? I suspect it's the name of your database. If so, remove one of the 2 dots between MyBase and dbo.

[tt][blue]MyBase.dbo.MyTable[/blue][/tt]

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[tuzojazz]

Thanks

Yes, MyBase is the name of my database.

I also tried

MyBase.dbo.MyTable

but it does not work, I get the same error.

when I want to try with my own computer using trusted connection (typing -T) it asks me for a password

 

[gmmastros]

From my limited googling.... I need to ask... Are you using a Sybase database? That error message appears to be sybase related.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[tuzojazz]

I'm using sql server 2000 database.

 

[gmmastros]

BCP is a utility. As such, it exists on your computer somewhere as bcp.exe

Can you find this file (search for it). Then, right click and tell me the version of the file that you are running.


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[mkal]

Try

bcp "MyBase.dbo.MyTable" out "c:\Bulktest\test.txt" -c -U"user1" -P"pass1" -SMyServer

And make sure the Directory c:\Bulktest exists on the server you are trying to run this on.