Connecting C# to MySQL database

[davidric]

Hi guys,
I'm trying connect in my C# the database from server.
But I always get the error "Unable to connect to any of the specified MySQL Hosts".

I have saw some topics in web but nothing was working here...

I think server is 198.91.81.5, database is mydatabase and uid/password is from the user I created. Yes, I have the connector from MySQL Installer and from VS.

Someone can help ?

 

[lylex10h]

The servers don't allow remote connections.

 

[davidric]

Yes, the servers allow remote connections... have that in cPanel but someone is missing here

 

[Anna]

Free hosting actually blocks remote through firewall, only localhost database connections will work.

Unfortunately I'm not sure we can tell cPanel to not show that option though since it is not going to work.

 

[davidric]

So, to I communicate my data in C# to database I can to use a script in PHP ?

 

[Anna]

Yes, that should work, as long as communication is done on an open port (only the most common, such as port 80 for web, would be open on free hosting), I wouldn't know how to code anything like that however

 

[davidric]

Thanks Anna That was a help