You should install client side SQL Server tools on the workstation.
>
>I have a BCP-command which I have used on the SQL_Server machine itself. No problem.
>Now I want the same BCP command to function on a workstation, so I did:
>
>- Define an ODBC connection. This connection works fine when using it via Foxpro.
>- Copy the files BCP.exe, bcp.rll, sqlncli10.dll,xmlrw.dll to a directory on the workstation.
>- Extend the BCP-command with -S {server} -U {login} -P {pwd}
>
>I get the message "data source name not found and no default driver specified". I do not specify the DSN in the BCP command, I don't even now how to do that, because in the manuals of BCP nothing is mentioned about a DSN.
>
>Any idea? TIA!
>
>Lennert
--sb--