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???