Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BCP data source problem
Message
From
13/09/2011 04:56:53
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
BCP data source problem
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01523372
Message ID:
01523372
Views:
151
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
Map
View

Click here to load this message in the networking platform