<div>
Hi!<br />
<br />
You will need to open port 3306 &nbsp;(default mysql port) for inbound connections on the WAMP Win machine. <br />
<br />
Regards,<br />
&nbsp; &nbsp; Tomas Helgi
</div>


Hi!

You will need to open port 3306  (default mysql port) for inbound connections on the WAMP Win machine.

Regards,
    Tomas Helgi

<div>
Kimputer, Tom:<br />
<br />
3306 is open in the firewall, anywhere else?<br />
I'm still getting the error &quot;Connection failed [hy000]mysql odbc 5.1 host 'adminstation02' is not allowed to connect to this server&quot;
</div>


Kimputer, Tom:

3306 is open in the firewall, anywhere else?
I'm still getting the error "Connection failed [hy000]mysql odbc 5.1 host 'adminstation02' is not allowed to connect to this server"

<div>
Tomas:<br />
<br />
That did it! can't thank you enough for the fast and accurate response!<br />
Iceland huh! how neat is that
</div>


Tomas:

That did it! can't thank you enough for the fast and accurate response!
Iceland huh! how neat is that

<div>
<div class="content wysiwyg-content">
This is a new installation.<br />
on a lan, 2 win7 pro desktops with 64bit os. One system has Wamp with mysql databases, essentially being used as a server. the other win7 runs ms access app with odbc to frontend the mysql. With mysql odbc installed on both, I'm still unable to connect. This same app connects odbc to a web server on the lan ok
</div>
</div>


This is a new installation.
on a lan, 2 win7 pro desktops with 64bit os. One system has Wamp with mysql databases, essentially being used as a server. the other win7 runs ms access app with odbc to frontend the mysql. With mysql odbc installed on both, I'm still unable to connect. This same app connects odbc to a web server on the lan ok

mysql odbc not connecting between 2 win7 pro systems

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.