General information
Forum:
Microsoft SQL Server
Title:
BCP data source problem
Environment versions
SQL Server:
SQL Server 2008
Hi all,
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only