Information générale
Forum:
Microsoft SQL Server
Titre:
BCP data source problem
Versions des environnements
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement