EdFred
Taxi to Parking
Ok, so I am trying to connect to a MySQL database on my server via Access (shut it, don't want to hear it)
I've edited my hosts file on the local machine, I've granted maximum permissions to myself as a user in phpadmin, I can ping the server, I've got the ports open on the router, I've even specified which IP address I'll be hitting the server from and I keep getting:
Connection Failed: [HY000][MySQL][ODBC 5.1 Driver]Unknown MySQL server host '//servername' (11001)
I've tried replacing the servername with the IP address of the server and it gives me the same error.
I've tried without the // and it tries to look at my computer instead of the server
I've tried //workgroup.servername and workgroup.servername
I can telnet the server ip with the port 3306 and it talks that way, so I'm not being blocked by the router, but still no joy.
Client: WinXP, Access2007, ODBC driver 5.1
Server: Server2003 with IIS 6.0 and MySQL 5.1
I've edited my hosts file on the local machine, I've granted maximum permissions to myself as a user in phpadmin, I can ping the server, I've got the ports open on the router, I've even specified which IP address I'll be hitting the server from and I keep getting:
Connection Failed: [HY000][MySQL][ODBC 5.1 Driver]Unknown MySQL server host '//servername' (11001)
I've tried replacing the servername with the IP address of the server and it gives me the same error.
I've tried without the // and it tries to look at my computer instead of the server
I've tried //workgroup.servername and workgroup.servername
I can telnet the server ip with the port 3306 and it talks that way, so I'm not being blocked by the router, but still no joy.
Client: WinXP, Access2007, ODBC driver 5.1
Server: Server2003 with IIS 6.0 and MySQL 5.1
Last edited: