I have been working on an application from my PC using MySQL and VB.net. When I run the application from the PC and include in the connection string the name of the server I need to connect to I can connect without any problems. When I move the application to the server to run from there I get the exception
“Unable to connect to any of the specified MySQL hosts.”
At first I figured this was because I was trying to access the MySQL database from the server instead of my PC so I put ‘localhost’ in the connection string and I still get this error.
I am using Studio 2005 to build the application and I am fairly new to VB.net and MySQL. Teaching myself. When the application is done I will be wanting to run it from the server with the users running it over the network and our company VPN. Is there something special I need to do in my developement to accomodate this?
I have read all the documentation for MySQL that I thought might address this issue and haven’t been able to come up with anything.
Any suggestions would be helpful. The server is a Novell version 6 server if that makes any difference.
Thanks for your help.
