Thank you very much Sergey. That was the solution.

>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