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.
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.