Hi Steve,
Just to clarify what Steve and Hector said (and they are both right), remote views and SQL pass-through will only work with the ODBC drivers. The OLEDB can be used via ADO. John Peterson has a whitepaper on ADO for the VFP developer on the MSDN website. Essentially, an ADO recordset is what you would be using -- which you can bounce back and forth to and from a cursor with RSToCursor() and CursorToRS() functions.
>I think I am missing something. Is there no way to query and OLEDB data source (MSSQL2K) in VFP7? I tried to make a new Remote View and dropped in my OLEDB connection string and it choked.
>
>How can I use OLEDB features in VFP7?
>
>Thanks.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05