Thanks John,

My main concern is whether using ADO for my current project will slow my development time by the learning. Is converting recordsets to cursors efficient, or do you more bind recordsets to grids and that sort of thing?

Can you use SQL-passthrough with an OLEdb driver?

Terry

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