mssql stored procedure call trought adodb, some problems

i have some troubles working with php+mssql ....

my problem is : 1) call select statement
2) call stored procedure statement

                     1 and 2 i call one by one......

for example when i am using this method...... (method_1)

===========================================
$result_set1 = $mssqlconnection->EXECUTE(" SIMPLE SELECT STATEMENT_1 ");

$result_set2 = $mssqlconnection->EXECUTE(" SIMPLE SELECT STATEMENT_2 ");

fetching $result_set1;

fetching $result_set2;

method_1 normally works and i can without any problems to fetch the data

but when i'am trying to call select at first and stored procedure i get the error like " fetch on non object "

$result_set1 = $mssqlconnection->EXECUTE(" SIMPLE SELECT STATEMENT_1 ");

$result_set2 = $mssqlconnection->EXECUTE("EXECUTE my_STORED PROCEDURE /without I/O params/ ");

fetching $result_set1;

how to correctly work with mssql stored procedures trought adodb, i was trying to use adodb help about stored procedures but nothing helps,

maybe someone can suggest something ......

thanks

seems that i am only one person that have this situation..... yeh.

Since when does MySQL have stored procedures????

Chris

sorry, maybe in my posts i have maded a mistake but i think that in all my posts i'am writing mssql, i think that mssql means Microsoft sql server

i talk about mssql server not about mysql

show me some of my posted lines where i have writed mysql