hello everyone,

I am using VB and oracle database, I hace 4 screens which I go from one to another by clicking on the menu items. I am using ado connection and this is a sample of how I declare my recordset

dim rs as As ADODB.Recordset
set rs = new ADODB.Recordset
rs.Open sql, db, adOpenStatic, adLockOptimistic

when I am done, I set
rs.close
set rs = nothing

When I go from one screen to another, after a while I get the following error:
"run time error '-2147467259(80004005)': unspecified error"
It does not happen at certain place, it happens in different places but all happens when I have then following on different places
rs.Open sql, db, adOpenStatic, adLockOptimistic

Can someone help me and give me a hint what this error is. Did anyone has this error before.
Am I accumalating something in the memory and how Would I know and get rid of them. Thanks for any help in advance.


[This message has been edited by farah (edited 06-29-1999).]