Hi Michael,
You need to use the OLE DB provider that ships with VFP 7.0. However, VFP 8.0 has an even later version of the provider that offers better .NET support. To see an example of how to use the provider with VFP, refer to the following article that I wrote. The first example has sample code that demonstrates using the provider.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxgen7/html/usingaspnetwithvfp7.aspThe article shows the code in C# but you could convert it or install the VB.NET source from the following link:
http://gotdotnet.com/team/vfp/downloads/VFP7OLEDBExampleVB.zip>Hi all.
>
>I am running Win 2K and Visual Studio .NET version 1. I have added ODBC driver support and the patch for the .NET framework 1.1 along with the SDK update and the mobile internet toolkit.
>
>
>I am using VB .NET and trying to use Visual FoxPro databases as a datasource (I have been programming in VFP 6 and 7). Creating the connection in the Server Explorer is no problem. Using it is a different matter. All I have managed to do so far is get error messages:
>
>1) When dragging a table onto a windows form:
> "You cannot use an OLE DB provider for ODBC drivers."
>
>2) when trying to create a connection using an OLEDBConnection and going throught the wizard process:
> "The connection you have created doesn't work with your current adapter."
>
>Anyone with any ideas.
>
>Thanks in advance.
>
>Michael
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi