Hi, Eric
ODBC does not support any of the new features for table beyond VFP 6. OLEDB does.
HTH
Beth
>I am trying to create a DSN to a local VFP table. I have VFP 9 installed and I keep getting an error everytime I try to create the connection.
>
>---------------------------
>Visual FoxPro ODBC Error
>---------------------------
>You must first install the current version of the Visual FoxPro ODBC Driver. Go to
http://msdn.microsoft.com/vfoxpro/downloads. Select Product Updates, then Visual FoxPro ODBC Driver.
>---------------------------
>OK
>---------------------------
>
>
>
>I have gone to the website and downloaded the odbc driver there. It is the same version of the one that comes with VFP9, but I downloaded and installed it anyway. Unfortunatly I still get the error. I need to use this to work with the SQL Server Data Import/Export wizard. Any ideas on how to fix this?