MS SQL Server Clients

Author

bcp problem

Rogers

2005-11-08, 4:09 pm

Can any one why I am facing the following error..

bcp pubs..authors out 'c:\Testing.xls' -c -S{local} -Usa -PDbPass

[Microsoft][ODBC SQL Server Driver]Syntax error or access violation

Thanks

Mike Epprecht \(SQL MVP\)

2005-11-08, 4:09 pm

bcp pubs..authors out 'c:\Testing.xls' -c -Usa -PDbPass

Without the -S, it will try the default instance on the local host. It is
generally best to give a server name and instance to ensure you don't
connect to the wrong server.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Rogers" <naissani@hotmail.com> wrote in message
news:u4Xd4U%234FHA.2616@TK2MSFTNGP12.phx.gbl...
> Can any one why I am facing the following error..
>
> bcp pubs..authors out 'c:\Testing.xls' -c -S{local} -Usa -PDbPass
>
> [Microsoft][ODBC SQL Server Driver]Syntax error or access violation
>
> Thanks
>
>

Rogers

2005-11-09, 9:23 am

I used the following query but it gave me an error..

bcp pubs..authors out 'c:\Testing.xls' -c -Usa -PDbPass

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '.'.

Thanks

"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:etsm8z%234FHA.2040@TK2MSFTNGP14.phx.gbl...
> bcp pubs..authors out 'c:\Testing.xls' -c -Usa -PDbPass
>
> Without the -S, it will try the default instance on the local host. It is
> generally best to give a server name and instance to ensure you don't
> connect to the wrong server.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Rogers" <naissani@hotmail.com> wrote in message
> news:u4Xd4U%234FHA.2616@TK2MSFTNGP12.phx.gbl...
>
>

Sponsored Links