Re: Accessing DBF files remotely.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Also, if the DBFs are FoxPro files you can use the FoxPro and Visual FoxPro
OLE DB data provider, downloadable from
msdn.microsoft.com/vfoxpro/downloads/updates (it works with all versions of
Fox files) and use a SQL linked server.

--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@xxxxxxxxxxxxxxxxxxx


"Davide" <rossetti71@xxxxxxxxx> wrote in message
news:7c768b02160ae68c88aa542aff4ac@xxxxxxxxxxxxxxxxxxxxxxx
Hello Pascal,

Hi,

We have a Vantive CRM running on SQL Server 2000 in Chile and we need
to access DBF files on a server that also runs SQL 2000 in Peru. How
can I get the SQL server in Peru to access the DBF files and then the
Chilean server to get the data from the Peruvian server? The idea is
to get both SQL servers talking together with encrypted connection.

Any clues?

Thanks,

Pascal Dorion
IT Manager Precision Peru

I'm not expert at all about the matter but i think: you can access DBF
files using ODBC drivers for dBase or FoxPro depending on the proper DBMS
(you can use a DTS , on the Peru server, to import via ODBC the dbf file
into SQL).



Then using a Linked Server from Chile-Server to Peru-Server could be a
solution?

Bye





.

Relevant Pages

  • Re: Insert from View to Table
    ... you could create a linked server and query it. ... 'Driver=Microsoft Visual Foxpro Driver; ... >> pushed the changes from foxpro into sql server. ...
    (microsoft.public.sqlserver.programming)
  • Re: Insert from View to Table
    ... A view is not required to access data on a linked server. ... provided by foxpro. ... pushed the changes from foxpro into sql server. ...
    (microsoft.public.sqlserver.programming)
  • RE: Creating a MSSQL linked server into a VFP database
    ... 207595 How To Do SQL Server 7.0 Distributed Queries With FoxPro .dbf Files ... Microsoft FoxPro Technical Support ... > trying to set up a linked server in SQL Server into a Visual FoxPro ...
    (microsoft.public.fox.programmer.exchange)
  • Import data from FoxPro 2.6
    ... What software can I use to import data into SQL Server or Access 2000 from a ... FoxPro 2.6 DOS .DBF? ...
    (microsoft.public.fox.vfp.forms)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)