RE: Error when using bcp

RE: Error when using bcp

 

  

The problem is probably in one of -S, -U or -P

> -----Original Message-----
> From: Shailesh Paliwal [SMTP:[Email Address Removed] Sent: Wednesday, November 20, 2002 9:26 AM
> To: LazyDBA.com Discussion
> Subject: Re: Error when using bcp
>
> 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] To: "LazyDBA.com Discussion" <[Email Address Removed] Sent: 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
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page