Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BCP data source problem
Message
 
 
À
03/10/2011 09:05:54
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Desktop
Divers
Thread ID:
01523372
Message ID:
01525456
Vues:
31
you are welcome

>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
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform