Database Issue

Results 1 to 2 of 2

Thread: Database Issue

  1. #1
    Join Date
    Dec 1969

    Default Database Issue

    Hi, I&#039;m having a problem with an Oracle database giving the following error:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80004005&#039; <BR><BR>[Microsoft][ODBC driver for Oracle][Oracle]ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit <BR><BR>I&#039;ve checked and I have closed all of my connections in the code. Apparently it doesnt close the connection immediately or at all cause I keep getting this error. <BR><BR>Here&#039;s the rest of the associated code:<BR><BR>strConn = "DRIVER={Microsoft ODBC for Oracle};; 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>&#060;% DBConn.close %&#062;<BR><BR>Any help or ideas is appreciated, thanks<BR><BR>J<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Try this....

    &nbsp;<BR>Replace<BR><BR>&#060;% DBConn.close %&#062;<BR><BR>with<BR><BR>&#060;% DBConn.close <BR> Set DBConn = Nothing%&#062;<BR>

Posting Permissions

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