SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Lost connection

  1. #1
    SitePoint Member
    Join Date
    May 2003
    Location
    Finland
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Lost connection

    I have a problem with my mysql connection. I get this error message:

    "ADODB.Recordset.1 error '80004005'
    SQLState: S1000
    Native Error Code: 2013 [TCX][MyODBC]
    Lost connection to MySQL server during query"

    This is how I open the connection on each page :

    connect_string = "Driver={Mysql}; Server=mysql2.xxxxx.xx; Database=dbname; UID=username; PWD=password"
    set Conn = server.createObject("ADODB.connection")
    Conn.open connect_string

    And this is how I close the connection:

    Conn.Close
    Set Conn = Nothing


    The problem seems to occur when the page has been open and inactive for a while and I try to either refresh it or move to another page. Does anyone know how to avoid this error??

  2. #2
    SitePoint Addict
    Join Date
    Mar 2002
    Posts
    327
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Is there some kind of timeout value that can be extended?

    Nick
    All4YourPC for all your PC needs. Custom software.
    Websites. Web marketing. Training.
    http://members.aol.com/nickjc67


Bookmarks

Posting Permissions

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