MDAC 2.6 and 2.7 don't come with the FoxPro ODBC driver. You need to go to Microsoft's web site and download the install for the driver: http://msdn.microsoft.com/vfoxpro/downloads/odbc.asp

>Thanks Jonathan
>
>I used the Component Checker to find out which version of MDAC is Installed on the Machine which does not allow me to creeate DSN (Windows XP OP).
>
>The version reported is 2.7 RTM (2.70.7713.4)
>
>When I try to create a system DSN, the screen listing the available drivers shows version 1.00.02.00 date 8/24/2001 for VFP driver.
>
>I checked on another machine with Windows 2000 and MDAC 2.6 SP2, and the add DSN screen shows version 6.01.8629.01 dated 12/15/1999
>
>On my opinion, the version of VFP driver for MDAC 2.6 appears to be newer (except for the date) than the one for MDAC 2.7 RTM.
>
>Since every time I try to create a new DSN a screen appears telling me that I need to install the current version of the Visual FoxProp ODBC driver, could it be that it is checking the version number regardless of the date?
>
>Oscar Corte
>
>
>
>>There are several ways, although I don't think there is an official way.
>>
>>1) Check the version of file "C:\Program Files\Common Files\System\ado\msado15.dll".
>>2) Check the registry key "HKey_Local_Machine\Software\Microsoft\DataAccess\FullInstallVer".
>>3) Download Component Checker from www.microsoft.com/data
>>
>>#3 is the best if you want to manually check your version.
>>
>>I've seen the most recommendations for #1 if you need to check programmatically.
>>
>>>How can I check the version of MDAC installed on a PC?
>>>
>>>Any hints are appreciated
>>>
>>>Oscar Corte