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 from dos

Author  Topic 

fisherman_jake
Slave to the Almighty Yak

159 Posts

Posted - 2001-11-08 : 01:55:49
Friends, I've had about enough with BCP so I need some help... I'm trying to generate a FORMAT FILE for a particular table using BCP, this is the command line I type in:

bcp "[central staging].[dbo].WSSuport_0" out e:\WS\WSSUPPORT_0.dat -S"OMQUANTSQL1" -U"lapidi" -P""

And I get this error:
SQLState = 37000, NativeError = 4060
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]
Cannot open database requested in login '[central staging]'. Login fails.

Any help or advice would be greatly I mean HUGELY appreciated..

Thanks in Advance..

==================================================
World War III is imminent, you know what that means... No Bag limits!!!
Master Fisherman
   

- Advertisement -