Hi Terry,
The most flexible way of using an OLEDB connection to SQL Server (or any server database for that matter) is through ADO. You can do SQL Passthrough type operations using an ADO Command object, which allows you to pump through SQL to the server and return a result-set as a Recordset object. If need be at that point you can use the RSToCursor() and CursorToRS() functions to move the data to and fro a Fox cursor.
>So now that ADO connection is working I have another question: What is the most recommended way to connect to SQL Server for SQL-Passthrough using dsnless connections to the new oledb provider? Or can the oledb provider be used by sql-passthrough?
------------------------------------------------
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