Help with connection!

Results 1 to 2 of 2

Thread: Help with connection!

  1. #1
    Charles Guest

    Default Help with connection!

    Hello, <BR><BR>I have a component which is accessing two databases, and currently getting a connection error when trying to access the second connection, can you please tell me what is wrong with trying to access two databases with the same component, can it be done? Even when I chane the name to objConn2 in function B, I still get the same error.<BR><BR>Thanks, <BR><BR>For example: <BR><BR>Function A contains: <BR>With objConn <BR> .ConnectionString = DB_CONNECTIONSTRING <BR> .Open <BR> End With <BR><BR>Function B contains: <BR>With objConn <BR> .ConnectionString = DB_CONNECTIONSTRING_GB <BR> .Open <BR> End With

  2. #2
    Join Date
    Dec 1969

    Default RE: Help with connection!

    Is objConn declared globally, outside any function or sub? You may not open a connection object if it is already open. If this is the case, use another variable in function B.

Posting Permissions

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