Hi Malcolm...

Sorry I did'nt follow this thread sooner.. I could have saved you some time..<s>

Anyway, for what you are doing, you can use the stored proc name as your Recordsource. For example:

oRs.Open("Exec Get_All_Open_Invoices",oConnection,3,4)

A few points:

1. Be sure you are using the SQL-Server OLE-DB Provider, not the ODBC Driver
2. Recordset sources can be a command object, a SQL Statement, or any valid
command the backend is capable of understanding...

HTH.....


>Hi all:
>
>ADO (using OLE DB) from SQL SERVER 7.0 is what I'm trying to implement.
>
>I can't seem to get a client side cursor when using the ADO COMMAND object to get a RECORDSET via STORED PROCEDURES. Is the combination of COMMAND Object/STORED PROCEDURES to retrieve a RECORDSET always read only or is there something I'm missing?
>
>Thanks in advance,
>
>Mal