MySQL C# question

[Darkmatter5]

For security reasons my hosting service makes me specify specific IP addresses for access to MySQL. My problem is, how do I go about building a Windows app that queries my MySQL server, but can be run on different client machines with different IP addresses due to different ISPs?

I can't go adding IPs for everyone who downloads and wants to use my application, to the whitelist. How do I go about this?

Thanks!!

[Cyb3rH4Xter]

There is no way a C# app can spoof an IP what I know of. The only method I can think of is if you run a VPN on a server and then configure your app to connect through that.

Then you only have to add one IP to the list.

[techgnome]

That's what a webservice would be for. your app would access the webservice component, which would in turn access the database. That way the client apps don't have direct access to the database (which they shouldn't)

-tg