You CREATE the connection object. You open it.
And then YOU IGNORE IT!
WHY did you code
addrecordset.Open strSQL, sConnection, 1, 3
addrecordset.Open strSQL, objConn, 1, 3
I'm not sure that's the problem, but it sure looks like it is.
But now I need to warn you: I do *NOT* think you will be able to use ADODB.Recordset.AddNew with that old MySQL ODBC driver. I believe it doesn't support ADO-based inserts or updates. I think you may have to resort to using a SQL INSERT command. Not sure on that. Things could have changed in the 6 or so years since I used MySQL with ASP. Give it a try, but if it doesn't work be prepared to use SQL INSERT instead.