OracleConnection or Any Connection


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
    Posts
    92

    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?

    modGlobals
    ...
    Public conn As OracleConnection
    ...

    conn.ConnectionString = sConnectionString
    conn.Open()

    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
    Location
    Duluth MN
    Posts
    353
    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.

    ...joe

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, 03:34 PM
  2. MSDE/NT Connection problem across domains
    By Will Rickards in forum Database
    Replies: 1
    Last Post: 04-06-2001, 04: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, 05:48 PM
  5. Connection Questions...............
    By markos in forum VB Classic
    Replies: 0
    Last Post: 04-03-2000, 01: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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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