Connectivity to FoxPro (dbf) from SQL 2005 on x64 Windows 2003

I have installed SQL Sever 2005 on an x64 bit machine running Windows 2003.
When I go to the ODBC Data Source Administrator, and click on the Drivers
tab, it only shows:
SQL Native Client
SQL Server
I would like it to show the "other" drivers that I see in other
installations - to connect to .mdb, .dbf, etc.
I tried installing MDAC 2.8, but it didn't affect the drivers shown in the
list.
Any suggestions? My goal is to write a SSIS package that connects to a
FoxPro (.dbf) file.
Thanks
PaulHi Paul,
There are two methods for connecting to Fox tables - OLE DB and ODBC. The
OLE DB data provider for VFP is only 32-bit compatible. There are no plans
to develop a 64-bit OLE DB data provider for VFP. I assume that the ODBC
drivers for VFP are also only 32-bit compatible (I'm not sure) but I am sure
that there won't be any new ODBC drivers for VFP.
Sorry to be the bearer of bad news.
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@.cindywinegarden.com
"Paul in Denver" <Paul in Denver@.discussions.microsoft.com> wrote in message
news:F0E93714-1075-446D-AEF9-48D70D0834E1@.microsoft.com...
>I have installed SQL Sever 2005 on an x64 bit machine ...

> Any suggestions? My goal is to write a SSIS package that connects to a
> FoxPro (.dbf) file.