I guess "shibu.test.employee" is not correct you can give only the table
name here .or correct path may dbo also be part of complete path.

Sheilesh
----- Original Message -----
From: "Shibu MB" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Wednesday, November 20, 2002 1:43 PM
Subject: Error when using bcp


Hi all ..

I am geting the following eror when i tried to use the bcp command
...Can anyone help me in solving this ??? Employee is the tablename.Test is
the database name and shibu is the loginname . Username and password is also
shibu


C:\>bcp "shibu.test.employee" out "c:\bcp1.txt" -S "PG" -U "shibu" -P
"shibu"
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
SQLState = 01000, NativeError = 53
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).


Thanks

Shibu



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.419 / Virus Database: 235 - Release Date: 11/13/2002

MS Sql Server LazyDBA home page