Unable to connect to any of the specified MySQL hosts.
-
Hi I created website in ASP.NET 2.0 and MYSQL. MYSQL data base is at remore server. I can connected to MySQL successfully but when I upload my site to Share hosting, it throws following error. I think ,On my local m/c I have installed MYSQL management tool so I can connect successfully but on shared hosting, it may not so this error is coming, Any clue how can we enable our remote shared host to connect to MYSQL. [MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.] MySql.Data.MySqlClient.NativeDriver.Open() +1142 MySql.Data.MySqlClient.Driver.Open() +69 MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) +89 MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() +11 MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() +257 MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() +117 MySql.Data.MySqlClient.MySqlPool.GetConnection() +113 MySql.Data.MySqlClient.MySqlConnection.Open() +309 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +31 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +112 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +92 ASP.test_aspx.getuser() in d:\hosting\5454799\html\Testing\test.aspx:25 ASP.test_aspx.Page_Load(Object sender, EventArgs e) in d:\hosting\5454799\html\Testing\test.aspx:12 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +50 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesA
Bajrang Singh Using .net 2.0 (VS2005)