HTTP 500.100 - Internal Server Error - ASP error
Posted by:
Pauzi Said
Date: December 13, 2004 12:48PM
I have mySQL 4.1.7-nt installed on my PC running WinXP Service pack 2.
I also have mysql odbc 3.51 driver installed.
When I defined a DSN and tested it during defining the DSN, it was connected successfully.
But when I wanted to open an ASP file from Inter Explorer, it gives me the following error:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
The technical error is :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10022)
/jobs/member_details.asp, line 130
I have the following as lines 129-131:
129:Set rsMember = Server.CreateObject("ADODB.Recordset")
130:rsMember.ActiveConnection = MM_connJobs_STRING
131:rsMember.Source = "SELECT memberid, firstname, lastname, sex, birthdate, addr1, addr2, city, state, postcode, employment_status, qualification, country, email, phone, fax FROM jobs.member"
I have set up the password for usercode 'root' and have properly set it up in the DSN.
Please help.
Thanks.