We could help more if we saw your proc but let say right now your proc creates a table by doing

select a,b,c into temptable from permtable

and then your app gets it's data via and ado select from temptable

if you change your proc to just

select a,b,c from permtable

then it will return the recordset a,b,c

in your app you get the results into your recordset by

rs = conn.execute(proc)