I have created an ODBC connection and run a SQL stored procedure name. It seems as though the only type of recordset that it returns from a stored procedure is a 'forward-only' type.

Dim rsTemp as Recordset
Set rsTemp=Connection.Openrecordset("myprocedure",dbOpendynamic)

(although in this case I want the dynamic type recordset)

The strange thing is, if I substituted the procedure name "myprocedure" with straighforward SQL syntax, it has no problem returning my the recordset of my choice

How do I control what type of recordset is returned from calling a SQL stored procedure ?

Thankyou if you can help

Keith