Re: MySqlException: Unable to connect to any of the specified MySQL hosts

[Shahid Syed]

Hi guys,

I've tried everything that people are advising and still nothing. When I run the ASP.NET configuration I get "An error was encountered. Please return to the previous page and try again."

So, I tried connecting to MySQL from code and I was successful with ODBC (OdbcConnection) using a System DSN only.

I've done the following:

* Installed Connector Net 5.2.2
* Have both Mysql.Data and Mysql.web in bin folder (well this didn't do any good as i had to add reference anyway to compile the code.)
* Added autogenerateschema="true" to machine.config
* Added connection string to web.config
o connectionString="server=localhost; user id=root; password=polo; persist security info=true; database=membership;" providerName="MySql.Data.MySqlClient"
* Also tried pooling to no use.
* Also tried serializing the connection object

I wanted to ask what version of Mysql are you guys using? I'm using 6 and I suspect there is something with Mysql 6. Anyone tried that with Mysql 6? And is it possible to use anything other than connector net for membership?

Thnaks

ShahG