I got the recordset with data ( recordcount > 0 ) , but now if
store proc is with Parameters then it's does not work. it gives error.

rs.OPEN(lcSQL,oConn,,,4)

lcSQL is store Proc.
oConn is Connection object

Please any one can help ?
Thanks
Mihir


>Hi
>
>Pl Any one help me, to get record set from SQL server store proc ?
>
>Here is my code...
>
>rs = CREATEOBJECT('ADODB.recordset')
>rs.cursorType = 1
>rs.OPEN(lcSQL,oConn)
>
>rs is recordset object
>oConn is connection object
>lcsql is sql server store proc
>
>When it is a simple select statement then it works fine , but when i use
>lcSql as some store proc ( store proc has SQL statement and it will return
>more than one record )
>
>I do not know what i have to pass in OPEN method OR what to set in
>recordset object... that will return me a recordset ( recordcount must be
>> 0 )
>
>
>Thanks
>Mihir