MySQL and .net remote connection

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jackgreat
Forum Newbie
Posts: 2
Joined: Tue Feb 16, 2010 11:16 pm

MySQL and .net remote connection

Post by jackgreat »

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
User avatar
clydoris
Forum Newbie
Posts: 10
Joined: Wed Feb 17, 2010 8:59 pm

Re: MySQL and .net remote connection

Post by clydoris »

i got the same problem, too. my webhost at free***tia said if i upgrade my account type from free account to premier, i should be able to use third party software. any help?
jackgreat
Forum Newbie
Posts: 2
Joined: Tue Feb 16, 2010 11:16 pm

Re: MySQL and .net remote connection

Post by jackgreat »

Webserver justhost.com provides access to database by third party software.
User avatar
clydoris
Forum Newbie
Posts: 10
Joined: Wed Feb 17, 2010 8:59 pm

Re: MySQL and .net remote connection

Post by clydoris »

thanks for the site..
Post Reply