>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?

No. SPT uses ODBC. If you use the OLEDB provider, you'll have to use ADO.

>
>(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.

Same answer.

>
>Thanks in advance,
>Kevin