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