Connector Failing - Install of latest version failing

[Nick Arnone]

I have a 2008 server. Installed is MySQL Connector 5.02.06.00.
It is registered. It shows it in the ODBC Data Source Administrator.
It shows the name as MyODBC 5.2 ANSI Driver within the ODBC Data Source Administrator.
It points to MYODBC5A.DLL.
The file is located in C:\Program Files\MySQL\Connector ODBC 5.2\myodbc5a.dll

My connection string is strConn = ("DRIVER={MySQL ODBC 5.2 ANSI Driver};SERVER=LOCALHOST;Port=3306;DATABASE=thedatabase;User=username;Password=password;OPTION=3;")

When I try to connect via an ASP I get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specified driver could not be loaded due to system error 126: The specified module could not be found. (MySQL ODBC 5.2 ANSI Driver, C:\Program Files\MySQL\Connector ODBC 5.2\myodbc5a.dll).




I am trying to installing the latest version 5.3.4
This is the error I get with either 64 bit or 32 bit version:
Product: MySQL Connector/ODBC 5.3 -- Error 1918.Error installing ODBC driver MySQL ODBC 5.3 ANSI Driver,
ODBC error 13: The setup routines for the MySQL ODBC 5.3 ANSI Driver ODBC driver could not be loaded
due to system error code 126: The specified module could not be found. (C:\Program Files (x86)\MySQL\Connector ODBC 5.3\myodbc5S.dll)..
Verify that the file MySQL ODBC 5.3 ANSI Driver exists and that you can access it.