SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
Thread: Lost connection
-
May 23, 2003, 04:39 #1
- 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??
-
Jul 12, 2003, 03:23 #2
- 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?
NickAll4YourPC for all your PC needs. Custom software.
Websites. Web marketing. Training.
http://members.aol.com/nickjc67
Bookmarks