MySQL and .net remote connection
Posted: Tue Feb 16, 2010 11:29 pm
Hi Guys,
I need some help and will be glad if anyone can help me out.
I have a .net program which needs to access mysql database hosted online (on a shared hosting server). Now the problem is most servers do not allow direct access to the database by an external program (3rd party). In order to ensure that my .net program can access the database i need to enter my IP address manually on the webserver config page and then only it works.
Now my program is such that if I give it to (for example) 100 people the program should be able to connect to the mysql db and work. But the webhosting company says I need to enter ip if mysql and my program needs to connect directly this option is not feasible. I cant ask 100 people for their IP.
What should I do ? My options :
- In what other ways can my .net program communicate with mysql database. (e.g. either thru PHP or what) A way which is kinda secure.
- is there any good hosting site (and not too expensive) which might allow unlimited remote open connections to mysql database. Here the IP issue won't come.
- any other solution you guys come up with
I would be grateful if anyone can help me.
Thank you,
cheers,
JG
I need some help and will be glad if anyone can help me out.
I have a .net program which needs to access mysql database hosted online (on a shared hosting server). Now the problem is most servers do not allow direct access to the database by an external program (3rd party). In order to ensure that my .net program can access the database i need to enter my IP address manually on the webserver config page and then only it works.
Now my program is such that if I give it to (for example) 100 people the program should be able to connect to the mysql db and work. But the webhosting company says I need to enter ip if mysql and my program needs to connect directly this option is not feasible. I cant ask 100 people for their IP.
What should I do ? My options :
- In what other ways can my .net program communicate with mysql database. (e.g. either thru PHP or what) A way which is kinda secure.
- is there any good hosting site (and not too expensive) which might allow unlimited remote open connections to mysql database. Here the IP issue won't come.
- any other solution you guys come up with
I would be grateful if anyone can help me.
Thank you,
cheers,
JG