Hi all.



I'm writing a small applicationm that connects to an Oracle Database. 

Since I'm using some reference (lookup) tables, I'm loading them all into 

application recordset Objects (using Visual interDEV and IIS under Windows 

2K, programming in VBScript).



I'm instanciating the Application Recordset Objects in the Global.asa 

under application_onstart sub.



Then, from the first page of the application I'm opening a connection to 

the DB, and then I run a simple sub that uses that single connection to 

send "select * from table" queries to the DB (one for each ref table), 

thus filling the application Recordset objects with the DB data.



The problem is that all the Recordset objects are empty after the sub 

finishes.



When I try running the same sub on non-application recordset objects 

(meaning Recordset objects instanciated on the same page, and not on the 

global.asa), they fill up with data nice and easy.



What am I doing wrong here ?



10x for you help ...