|
![]()
Right now i am in a web based project and i have completed the coding of it.In the local system it is working fine but actually i am trying to host it does not work.
My Issue is that actually i have downloaded a mysql-connector-net-1.0.8-RC-noinstall.z... and setting its reference for the connection with MYsql and it is working fine.But when i tried it to publish that project.I have done the following things.
>I have uploaded all the aspx files into the server workspace.
>Uploaded mysql-connector-net-1.0.8-RC-noinstall.z... package into the bin folder.
>Created the Mysql databases into it .
Problem :
I dont know how to give reference to the mysql connector remotely so that aspx pages can communicate with database.
It is showing this error message:
[[MySqlException: Unable to connect to any of the specified MySQL hosts]
MySql.Data.MySqlClient.NativeDriver.Open... +1451
MySql.Data.MySqlClient.MySqlConnection.O... +314
Version1.WebForm1.loadValues(String tableN
How to connect a MySQL database with ASP.NET 1.1 using mysql-connector-net-1.0.8-RC-n... remotely?
1. MySql has very strict access polices. Check that your User on the Server system has access permissions to the Database.
You should give access permissions to the user that you have specifiec in the connectionString for specified HOST. If your database is on the different system then this should be checked.
2. I think there is no need to install the Mysql Connector on the server as you have copied that in the BIN folder.
|
