BOL:
bcp "pubs copy..my table" in authors.txt -c -q -Sserver_name -U"my name"
-P"my pass
? Remove quotes round servername?

> -----Original Message-----
> From: Shibu MB [SMTP:[Email Address Removed] Sent: Wednesday, November 20, 2002 12:00 PM
> To: LazyDBA.com Discussion
> Subject: RE: Error when using bcp
>
>
>
> Hi ....
>
> I tried that and still i am getting the error
>
>
>
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn>bcp "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
>
>
> -----Original Message-----
> From: Thiagarajan Gopalakrishnan
> [mailto:Thiagarajan.[Email Address Removed] Sent: Wednesday, November 20, 2002 4:51 PM
> To: Shibu MB
> Subject: RE: Error when using bcp
>
>
> Hi
> I
> f u could go to dir c:\mssql7\binn and run the same statement it should
> work.
>
> c:\mssql7\binn> bcp db.dbo.table out c:\bcp1.txt -C -S server -U User -P
> Pwd
>
> Thanks and Regards
>
> PG Thiagarajan
>
>
> -----Original Message-----
> From: Shibu MB [mailto:[Email Address Removed] Sent: Wednesday, November 20, 2002 4:28 PM
> To: LazyDBA.com Discussion
> Subject: RE: Error when using bcp
>
>
>
> Sheilesh......
>
> Still I am getting the same error ...
>
>
> C:\>bcp "dbo.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
>
>
>
> -----Original Message-----
> From: Shailesh Paliwal [mailto:[Email Address Removed] Sent: Wednesday, November 20, 2002 2:56 PM
> To: LazyDBA.com Discussion; Shibu MB
> 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] **************************************************************************
> **
> THIS E-MAIL IS CONFIDENTIAL and intended solely for the use of the
> individual to whom it is addressed.
> If you are not the addressee, any disclosure, reproduction, copying,
> distribution,or other dissemination
> or use of this communication is strictly prohibited. If you have received
> this transmission in error please
> notify iSOFT plc immediately either by replying to this e-mail or by
> telephone on +44 (0) 161 233 8800
> and then delete this e-mail.
>
> Any views or opinions presented are solely those of the author and do not
> necessarily represent those
> of iSOFT plc [or its associated companies].
> **************************************************************************
> **
>
>
>
> ---------------------------------------------------------------------
> 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