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

Hi 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


[quoted text, click to view]