Results 1 to 3 of 3

Thread: runtime error 91 and sql

  1. #1

    Thread Starter
    Member
    Join Date
    Oct 2000
    Posts
    42

    Question

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


  2. #2
    Hyperactive Member
    Join Date
    Feb 2000
    Posts
    284
    I am not sure off the top of my head what error 91 is but could it be that your database is not started?

  3. #3

    Thread Starter
    Member
    Join Date
    Oct 2000
    Posts
    42
    The database seems ok, but for some reason the one table is unavailable at times.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width