ISP Hosted database
"Vic Spainhower" <[email protected]> Fri, 20 Oct 2006 16:11:12 -0700
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <002901c6f49d$0ad82ca0$320fa8c0@VicXP> |
Hello, I don't know if this is a proper question for this list but I do know there are some very knowledgable people here who will be able to send me in the right direction or inform me that I'm off base. I've built a web site for receiving entries for shows (type of show doesn't matter could be horse, dog, cat, car etc.) . These show entries are stored in a MySQL database. When an entry is received the information is not only captured in the MySQL database but it is also emailed to the Show Secretary. The Show Secretary has an Access Database that can connect to the web site and pick up these entries which are then copied to the Access database. That's the 30,000 foot picture of what's going on. Now here's my problem. This site is hosted at an ISP in a shared environment because I cannot afford to have a dedicated server until this thing can get going (if it ever does). The ISP requires that each user's IP address be white listed and the problem being is that many (if not most) of the users are on dial-up so the IP address is not static. So in short it doesn't work for them. I'm told that to eliminate the white listing requirement would mean turning off the fire wall which would open a real can of worns. If this is in fact true I cannot imagine any ISP not making white listing IP addresses mandatory for remote connections. On the other hand there must be a way to secure the environment and not have to use the IP address. I like the way it currently works because it is a seamless connection to the remote database making it very easy to use which I really need as most of the users are not computer savy. Can anyone offer ideas on either an ISP that does not require white listing IP addresses in a shared environment or possibly another approch to accomplishing the same thing? Thanks very much! Vic