about connect to mysql using c sharp

[Shenno]

hiz all

i wanna ask about connecting to mysql database stored on web server using c sharp windows application on my pc.


is it requires to allow remote connection on mysql server ??

would be gr8 if any one tells me what setting i wanna edit to enable that kind connection .


THX in advance.

[Popescu Mihai]

you have to use at least ADO.NET... and you need a .NET data provider for MySql...
you can find some informations here...

http://dev.mysql.com/tech-resources/articles/dotnet/index.html#ADO.NET

[Shenno]

i know that issues on client, what am talkin' about is server setting,
do i have to allow remote connection on web server to be able to access database on web server from my client?
what setting should i set on server to enable my client to connect to database on that web server ?

thx

[Curtis Rutland]

My experience is only with MSSQL, not MySql, but logic says that yes, you must enable remote connections to connect remotely.

[Shenno]

thx but i know about mssql. what am seeking to is specific answer yes or no :/

[Curtis Rutland]

Why don't you try it out for yourself? You're spending an awful lot of time looking for an expert to tell you the answer, when all it would take is a second (or even virtual) computer and a quick test with the setting one way, then the other.

I'm willing to stake my reputation and guess that yes, it will require remote connections. What else is connecting via the web from a different PC but a remote connection?

[Shenno]

hosting companies like godaday and host gator.

these companies allow remote connection. or it's known to be unsafe so they restricted it by default ??

[Shenno]

i find what am looking for, thx all..

this link explain the issue i wanna know

http://www.hostgator.com/tutorials/cpanel/hgx3/allowing-remote-mysql-connections.htm

THXXX