Actually, this doesn't appear to need a recordset at all:

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

Dim DBConnection

Set DBConnection = Server.CreateObject("ADODB.Connection")
DBConnection.Open "InsertConnectionStringHere"

DBConnection.Execute "EXECUTE PROCEDURE StoredProcGoesHere;"

Set DBConnection = Nothing

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

Michael Fisher wrote:

> Here is an example:
>
> Dim objConn, strSQL, rsGetCustomerName
> Set objConn = Server.CreateObject("ADODB.Connection")
> Set rsGetCustomerName = Server.CreateObject("ADODB.Recordset")
>
> custID = "1000002"
>
> strSQL = "spSeminarGetCustomer " & custID
> rsGetCustomerName.Open strSQL, objConn, 3
>
> On 7/27/05, kevtey <kevtey@...> wrote:
>
>>hi i would like to know how can i call a stored procedure inside
>>firebird DB.
>>
>>in isql i tried select * from <procedure_name>
>>
>>i put this inside ASP
>>prscommon.locktype =2
>>pstrsql = "select * from reset_generator1;"
>>prscommon.open pstrsql , padocon
>>
>>but i got error of table not found..
>>how can i called the stored procedure???
>>
>>
>>
>>
>>
>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>>Visit http://firebird.sourceforge.net and click the Resources item
>>on the main (top) menu. Try Knowledgebase and FAQ links !
>>
>>Also search the knowledgebases at http://www.ibphoenix.com
>>
>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>>
>>
>>________________________________
>>YAHOO! GROUPS LINKS
>>
>> Visit your group "firebird-support" on the web.
>>
>> To unsubscribe from this group, send an email to:
>> firebird-support-unsubscribe@yahoogroups.com
>>
>> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>> To unsubscribe from this group, send an email to:
>> firebird-support-unsubscribe@yahoogroups.com
>>
>> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>>________________________________
>>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>