Re: Accessing DBF files remotely.
- From: Davide <rossetti71@xxxxxxxxx>
- Date: Thu, 10 Aug 2006 13:03:23 +0000 (UTC)
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
.
- Follow-Ups:
- Re: Accessing DBF files remotely.
- From: Cindy Winegarden
- Re: Accessing DBF files remotely.
- Prev by Date: Re: partnumber as string subtracts
- Next by Date: Re: partnumber as string subtracts
- Previous by thread: Re: Pass User and PW in a dtsrun batch file
- Next by thread: Re: Accessing DBF files remotely.
- Index(es):
Relevant Pages
|
