runtime error 91 and sql

[marilyn934]

There's a problem running my app from VB when I'm also doing some querying in SQL. To get around getting the error 91 when I try to login to my app within VB, I have to minimize and go into SQL and select * from reports.
I'm not sure what the two have to do with each other, but I'm connecting to an oracle DB like so:
Public Const cOrainstance = "SOMET"
Public Const cOraOpt = dbReadOnly + dbSQLPassThrough
gOraConnect = "ODBC;DSN=" & cOrainstance & ";UID=OPS$" & usr & ";PWD=" & pwd
Set gOradb = DBEngine.OpenDatabase("'" + cOrainstance + "'", False, False, "" + gOraConnect + "")

Any ideas???

[Bigley]

I am not sure off the top of my head what error 91 is but could it be that your database is not started?

[marilyn934]

The database seems ok, but for some reason the one table is unavailable at times.