Currently, OLE DB is only available if you are using ADO. The Provider string can not be used in lieu of a connection string for either Remote Views or SPT.

Once you have an ADO recordset, you can turn that into a cursor; however, the overhead may be too much so you might want to look at using ODBC.

HTH.

>Hello all
>
>Questions
>=========
>1. How can I setup SQLOLEDB ? (is it the same as ODBC?)
>
>2. How can I connect to SQL server from VFP through SQLOLEDB?
>
>3. Can I use SQL Pass through or Remote Views after the connection.
>
>4.There any coding samples for that kind of communication ?
>
>Thanks in advance
>Peter