DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: OracleConnection or Any Connection

  1. #1
    Join Date
    Jan 2007

    OracleConnection or Any Connection

    Does the connection object have limited scope?

    I declare it in a global module and then open then open the connection in the same module with the intent that it would be availbe to the entire application. I test it after i open it to make sure it is open and it is then when I am in my queries module using a command to executequery it says the command is not open?

    Public conn As OracleConnection

    conn.ConnectionString = sConnectionString

    then in the partQueries module
    GetProductTypes = cmd.ExecuteReader

    i don't get how or y the connection would get closed when i didn't explicitly call it. is there a reason?

  2. #2
    Join Date
    May 2004
    Duluth MN
    Hard to debug from your example

    I assume your assigning conn as the connection when you create your command object. Can you post more of the code your using in the partQueries module.


Similar Threads

  1. VB doesn't wait until SQL-query has finished
    By Daniel Teufert in forum VB Classic
    Replies: 2
    Last Post: 04-24-2002, 02:34 PM
  2. MSDE/NT Connection problem across domains
    By Will Rickards in forum Database
    Replies: 1
    Last Post: 04-06-2001, 03:50 PM
  3. Blocking problem with DSN-less connection
    By Adam Dawes in forum VB Classic
    Replies: 3
    Last Post: 12-21-2000, 12:50 PM
  4. Replies: 1
    Last Post: 10-24-2000, 04:48 PM
  5. Connection Questions...............
    By markos in forum VB Classic
    Replies: 0
    Last Post: 04-03-2000, 12:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center