Return from Sql Procedure

[maheshmehta]

I wrote a simple Stored Proc.
Its working fine if i am working throgh command object
But if i am using simple
Conn.Execute "Exec proc_name 'paramters'"
it throughs me error

"Operation not allowed if object is closed"

The proc is like

CREATE PROCEDURE Just_Try @fieldname varchar(50), @username varchar(50)
AS
Insert into users (user_name) values('mahesh')
Select userid from users
GO

Now if i remove the Insert statement it works fine

Any help Please

Mahesh

 

[tlbroadbent]

Try adding Set Nocount On to the procedure. Place the statement just before the Insert statement. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.