bcp : Error trying to connect !

Platform:
Windows XP, SQL Server 2000 sp3a enterprise
We tried to use bcp to extract a simple table into a file
serious error:
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
SQLState = 01000, NativeError = 2
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
Any idea please !!
there is no sufficient ressources on the net :(
Thanks.
Maggie"404 found" <404found@.discussions.microsoft.com> wrote in message
news:2B3F0821-E3CD-4555-8D1E-2D9949642128@.microsoft.com...
> Platform:
> Windows XP, SQL Server 2000 sp3a enterprise
> We tried to use bcp to extract a simple table into a file
> serious error:
> SQLState = 08001, NativeError = 17
> Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
> exist or access denied.
> SQLState = 01000, NativeError = 2
> Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
> (Connect()).
> Any idea please !!
> there is no sufficient ressources on the net :(
> Thanks.
> Maggie
What does your bcp command look like? It sounds like you didn't specify a
server, or valid login credentials to the server.
Here is a sample one that works on a base table:
bcp Northwind.dbo.Customers out
C:\temp\Customers.dat -SMySQLServer -Usa -PMyPassword -n
Rick Sawtell
MCT, MCSD, MCDBA|||Resolved !
c:> bcp base.dbo.table out "c:\tt.txt" -S server\instance -U sa -P password
instance name and server at the last of command !
"404 found" wrote:
> Platform:
> Windows XP, SQL Server 2000 sp3a enterprise
> We tried to use bcp to extract a simple table into a file
> serious error:
> SQLState = 08001, NativeError = 17
> Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
> exist or access denied.
> SQLState = 01000, NativeError = 2
> Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
> (Connect()).
> Any idea please !!
> there is no sufficient ressources on the net :(
> Thanks.
> Maggie