General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only