The latest OLE DB provider comes with VFP8. For the release date for the updated version see
Re: Latest OleDB driver Message #
791782. You can create VFP linked server with VFP ODBC driver or VFP OLE DB provider. The first one is faster than second one but it has problems with writing to memo fields.
>I have to update a DBF from SQL Server 2000. What needs to be installed on my SQL Server server to do this? I know that ODBC drivers work in creating a linked server on one of our servers, but the ones we have do not work on the production server. I have to check, but I think the production server is Win 2000.
>
>Is there an OLE DB driver? Do we still need ODBC if using OLE DB? Is there something else we should look at?
>
>Thanks,
>Cheryl
--sb--