hi friends,

pl. help finding solution for this.

stored procedure in sql server.
create procedure sp_employee @ename nvarchar(10)
as select * from employee where ename like @ename + '%'

cmd1_click()
set rs=new adodb.recordset
strsql = strsql = "exec sp_employee'" & txtename.Text & "'"
rs.open strsql,cn,adopenstatic
set datagrid.datasource = rs
end sub

when i pressing/clicking cmd1, i am getting error like run time error 7004 and The rowset is not bookmarkable.
what is the reason/problem. please mail me solution as early as possible.
_______________

if i am trying in different way of writing & i am getting results.
i.e., without passing any IN parameter to procedure.
simple select statement.

store procedure like this
create procedure sp_emp as select * from employee

cmd_click()
set rs=new recordset()
strsql="exec sp_emp"
rs.open strsql,cn,adopenstatic
set datagrid.datasource=rs
end sub.

here i am not getting any error what is the different between 2 prog.

Thanks in advance.
bye.