I have a test script written in ASP classic to connect to a remote MySQL database from a Windows 2008 server. I am using the ODBC driver - MySQL ODBC 5.2 ANSI Driver.
Unfortunately I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 5.2(a) Driver]Can't get hostname for your address
I have looked online and I understand one solution is to add skip-name-resolve to a my.ini MySQL installation file. However I don't have MySQL installed on the windows server as I don't actually need it. The driver should be enough.
I know the script works because I have tried it on another Windows 2008 server. I have tried opening port 3306 for both inbound and outbound using the Windows Firewall rules.
Any help would be appreciated.