Re: ISP Hosted database
"Jan Theodore Galkowski" <[email protected]> Fri, 20 Oct 2006 19:50:19 -0400
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
Vic, You need a proxy server script running on your ISP which takes posted or otherwise provided data from users and does with it what a direct connect would do. From your description, I don't entirely understand how it's done, but it seems that you have some kind of client which goes to the database directly. What you want is users to use a browser to get to one place on your Web site, and that place then provides the information they key in/upload/sync to the database, mediated by some scripts. - Jan On Fri, 20 Oct 2006 16:11:12 -0700, "Vic Spainhower" <[email protected]> said: > 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 > > > > > > > > -- Jan Theodore Galkowski (o°) [email protected] http://tinyurl.com/qty7d -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]