VB ADODB - Query returns no row

Question

Hello,

I am using adodb to connect to oracle database. My VB script returns an empty record for a sql query, but when I issue the same query from SQL Developer or from sql command prompt, the query returns a row.

Line that is causing error ... dbresult = dbconnection.Execute(sql)

I ran it through a debugger, dbresult was null. After a couple of minutes, the value is populated in dbresult. dbresult.Field.Item("") is null initially, but shows up the value when i try it again. I added a wait 150 seconds to wait for dbResult to be populated in the script after the Execute() statement, but it din't help. dbresult.BOF and EOF are set to true, indicating that there is no row, but after EOF changes to False.

The machine has MDAC 2.8 and Oracle 10 db. I read here http://www.mofeel.net/27-microsoft-public-data-ado/3080.aspx# that there is a known problem with MDAC 2.0.

Any pointers would be helpful.

Thanks in advance.