Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BCP data source problem
Message
De
13/09/2011 04:56:53
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Titre:
BCP data source problem
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Desktop
Divers
Thread ID:
01523372
Message ID:
01523372
Vues:
152
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
Fil
Voir

Click here to load this message in the networking platform