Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

using bcp with a linket server

Status
Not open for further replies.

Jamfool

IS-IT--Management
Apr 10, 2003
484
GB
EXECUTE sp_dropserver 'DBASE_LINKER', 'droplogins'
EXEC sp_addlinkedserver 'DBASE_LINKER','Jet 4.0','Microsoft.Jet.OLEDB.4.0','c:\bcp\',NULL,'dBase IV' ;
EXEC sp_addlinkedsrvlogin 'DBASE_LINKER', 'false', NULL, NULL, NULL

heres the connect for the linked server, but how do i go about using bcp to access the tables, and dump them to comma delimited text files.

bcp DBASE_LINKER...XPETER.DBF out C:\bcp\XPETER.TXT/c -t\, -S transfer2 -q -U -P

is this correct? any help would be great

the error i get is

Error = [Microsoft][ODBC SQL Server Driver]
[SQL Server]Cannot open database requested in login 'DBASE_LINKER'. Login fails.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top