DB connection problem

Results 1 to 2 of 2

Thread: DB connection problem

  1. #1
    Join Date
    Dec 1969

    Default DB connection problem

    I&#039;m having a problem with mutiple session error on an oracle data base. The code associated with the connection is below.<BR><BR>strConn = "DRIVER={Microsoft ODBC for Oracle}; server=sff_p.eft.trg.com; UID=" & userid & "; PWD=" & password & "" %&#062;<BR>&#060;% <BR> dim DBconn<BR> set DBconn = Server.CreateObject("ADODB.Connection")<BR> DBConn.Open strConn<BR>%&#062;<BR><BR>The application does a number of queries on a number of different pages. I can&#039;t seem to get the connection to close on every page or figure out how to keep it open so I dont have to open it on every page and thus get the error. Anyone know the solution?<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: DB connection problem

    Stick the close connection code in a seperate file and include it at the header of each file. Don&#039;t know if this works... it&#039;s just an idea you might like to try.

Posting Permissions

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