John :o)

It worked!! Thanks so much.
Now I can make all my data calls via Stored Procedure.

By the way, I'm putting all my data calls in COM (DCOM to be exact).
Do you see a problem in this? I thought perhaps it would cut down on network traffic.

Regards,

Mal



>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