I am trying to access an MySQL server from asp, I have checked that all
the tables ect exist using webmin I use the following code just as a
test to work out how to use it:
dim adocon
Dim rstest
Dim strsql
set adocon = server.CreateObject("ADODB.Connection")
adocon.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};
Server=192.168.1.20; Database=anope; UID=****; PWD=****;
port=3306; Option=3"
adocon.open
The error message I get is
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver]Lost connection to MySQL server during query
/irc/test.asp, line 10
How to I either fix my asp code so it will not lose the connection, or
fix the MySQL server so that it does not discconect me (as I am not
sure what doing it).
<-- edit
hide the password and username from hackers etc thatmay come accross it.
let me know if they wheren't real ones just examples
-->
Edited by dj air - 13 May 2005 at 7:13pm