how i will get recordset from stored procedure in sql server to visual basic 6

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

how i will get recordset from stored procedure in sql server to visual basic 6

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-11 : 09:22:44

mangesh writes "1)
suppose i have created one stored procedure in sql server like
create procedure r_recordset as
begin
select * from employee

end

i want to call this recordset in visual basic
for example
dim cmd as new adodb.command
dim rs as new adodb.recordset
with cmd
.activconnection=cn
.commandtext=r_recordset
.commandtype=adstoreproc
end with
set rs=cmd.execute

Is this the correct method to call recordset from sql server to visual basci 6

2)
how many types of trigger are in sql server 7

3)
how to catch trigger error in visual basic 6.0"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources