Kevin,

Craig's answer to your question may be a little misleading. You can NOT use SQLExec() with an OLEDB provider or an ADO connection object. You CAN send SQL commands to the back end through the ADO connection, but you will get the results back as an ADO recordset.

However, you CAN make an additional ODBC connection with SQLConnect() or SQLStringConnect() and use SQLExec() on that connection, which will return VFP cursors.

BOb

>Question on a VFP app that is using SQL Server 2000 as the back-end database.
>
>If one makes a connection without a DSN (basically, using OLE-DB Provider instead), is it still possible to use pass-through?
>
>(Basically, if I connect with the long connection string using the OLE-DB Provider to get a connection handle, can I still use SQLEXEC, or do I have to use ADO for everything?) I do realize that one can convert ADO to Cursor and back, but was still curious about pros and cons.
>
>This is in VFP 6. If the answer is 'no', that I must use ADO and can't use SQLEXEC, follow-up question is whether this can be done in VFP7.
>
>Thanks in advance,
>Kevin