Hi George,

There's the latest version of VFP OLE DB provider at http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en#filelist. The VFP8 OLEDBProvider Readme.doc explains how to call stored procedures using ADO. AFAIK, you cannot access p-views through ADO.

>I can do this in VFP...
>
>nConnectionHandle = SQLCONNECT('sqlremote')
>SQLEXEC(SQLEXEC(nConnectionHandle, 'select * from test', 'temptest')
>and I can do this
>? SQLEXEC(nConnectionHandle, 'use pubs')
>? SQLEXEC(nConnectionHandle, 'sp_who')
>
>and I can do this in VB...
>'sActivityDate is my parameter that I would like to pass to FoxPro...
>'You can use any date for the test...
>sSQL = "select * from " & sView1 & " where trandate = {^" & sActivityDate
>& "}"
>Set RS1 = Cnn.Execute(sSQL)
>
>The question is how does one run a VFP stored proc or send a parameter for a view from VB?
>TIA
>GAB