Hi Tim,

That's not the way you use ADO in VFP. The article ADO Jumpstart for Microsoft Visual FoxPro Developers by John V. Petersen should get you started http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxgen/html/adojump.asp.

>I have tried the following connections string withing foxpro, does anyone know why it is not working or maybe FoxPro does not support sql oledb?
>
>Here is my sample code:
>
>mdhandle= Sqlstringconnect("Provider=SQLOLEDB.1;Password=mypassword;Persist Security Info=True;User ID=myname;Initial Catalog=server1;Data Source=mydata")
>
>Why will the above code not work? The oledb should be much faster than the ODBC driver?
>