I have to connect mysql database through asp.net application.
But my website is on linux based server.
my database is on another server phpmyadmin which is not linux based.
when i try to connect it it gives me exception like following.
Unable to connect to any of the specified MySQL hosts. at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in :0 at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] in :0 at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection () [0x00000] in :0 at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection () [0x00000] in :0 at MySql.Data.MySqlClient.MySqlPool.GetConnection () [0x00000] in :0
but when i run it locally it working fine for me.
my connection string is also right.
Please help me to solve this problem.
Thanks in advance.