I have mySQL 4.1.7-nt installed on my PC running WinXP SP 2.
I also have mysql odbc 3.51.10 driver installed.
When I defined a DSN and tested it during defining the DSN, it was connected OK.
But when I wanted to open an ASP file from Internet 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, generated auto by Dreamweaver:

129et 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.