Connect to MYSQLon Vista 64 bit server from XP

Question

I have an vb.net APP that uses MYSQL and it has worked fine running between 2 xp computers using Visual Studio 2005.  I recently upgraded the APP to run under Vista 64 bit using Visual Studio 2008, and now when I install the new publish on the XP computer, it will not run.    The error is "Unable to connect to any of the specified Mysql Hosts"   I think it may be related to a firewall issue, but I can not see a way in Windows Firewall to open port 3302 on Vista 64 computer.  I have added mysql as a permitted program with access rights.   I tried loading Navicat on the XP client computer and it could not connect to the new Vista mysql server but could see the old one that was running under XP.

The xp clientt computer is running the older framework v 2.0.50727 whereas vista machine has Framework 3.5 with SP1.     Anyone have an idea what I need to tweak to allow this app to have access to the MYSQL on the vista 64 bit computer.       The mysql.data is assembly version 5.0.7.0.

Thanks,
David

Answer 1

I have a vb.net APP that uses MYSQL and it has worked fine running between 2 xp computers using Visual Studio 2005.  I recently upgraded the APP to run under Vista 64 bit using Visual Studio 2008, and now when I install the new publish on the XP computer, it will not run.    The error is "Unable to connect to any of the specified Mysql Hosts"   I think it may be related to a firewall issue, but I can not see a way in Windows Firewall to open port 3302 on Vista 64 computer.  I have added mysql as a permitted program with access rights.   I tried loading Navicat on the XP client computer and it could not connect to the new Vista mysql server but could see the old one that was running under XP.

The xp client computer is running the older framework v 2.0.50727 whereas vista machine has Framework 3.5 with SP1.     Anyone have an idea what I need to tweak to allow this app to have access to the MYSQL on the vista 64 bit computer.       The mysql.data is assembly version 5.0.7.0.

Thanks,
David

Answer 2

Hello,

I am moving this post to Visual Basic General Forum so you can get better and quicker response as this forum is for the database development tools of visual stuido.

Thank you for your understanding.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Send us any feedback you have about the help from MSFT at [e-mail].

Answer 3

You might want to post this question in the MySQL forums if the below link doesn't help you.

http://forums.mysql.com/read.php?38,13350,13350

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 4

Hi,
Do you mind posting your code for connecting to mysql?

Thanks,
Eric

---

Please remember to mark helpful replies as answers and unmark them if they provide no help.

Answer 5

Thanks for everyone's suggestions.  I did post on the MYSQL forum and a SUN employee responded with a question about whether I loaded the 32 bit MYSQL server or the 64 bit.   That was the issue.  I had loaded the 32 bit which would run ok on local machine, but not work on remote computers.  I installed the 64 bit version which freed up port 3306 on firewall and everything works fine now.

Answer 6

Thanks for the suggestion.  I did post on the MYSQL forum and a SUN employee responded with a question about whether I loaded the 32 bit MYSQL server or the 64 bit.   That was the issue.  I had loaded the 32 bit which would run ok on local machine, but not work with the remote computers.  I installed the 64 bit version which freed up port 3306 on firewall and everything works fine now.