I use store procedures in this way, in this example is
can pass parameters to the store
Dim $oConn1
Dim $oCmd
Dim $strConnetion
$strConnetion = "Dsn=Order;Uid=;Pwd=;"
$oConn1 = ObjCreate("ADODB.Connection")
$oConn1.open($strConnetion)
$oCmd = ObjCreate("ADODB.Command")
$oCmd.ActiveConnection = $oConn1
$oCmd.CommandText = "call UpdateOrderTest('1234')"
$oCmd.Execute ( Default, 0, -1 )
$oConn1.close
MsgBox(0,"","Update OK !!!")
the my store is "UpdateOrderTest" and "1234" is tha parameter.
I use the database mysql