Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #1280
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Access MySQL files directly on internet sites |
| Date | 2011-06-07 07:24 -0500 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <isl59q$kan$1@speranza.aioe.org> (permalink) |
| References | <5jrru6h02ibba5hvs2ia7bmv65knuv9tug@4ax.com> |
Dick, You can access mySQL very easily over the internet but most IT shops will not allow it. That makes the web site very prone to attacks / hacks. Most IT shops will require that you have a web service / wcf service running on their box that serves the specific pieces to the client. It is extremely easy to write a WCF service that sits in your web site's bin directory. Because it is local to the client's network, the mySQL remote restrictions do not apply although you will still have to have a userid / pwd that gives you access to the tables you require. The other benefit to using WCF is that you can use the ADO.Net driver for mySQL. Regards, Willie "D.J.W. van Kooten" wrote in message news:5jrru6h02ibba5hvs2ia7bmv65knuv9tug@4ax.com... A client gets data using MySQL on his website. Currently, we import CSV files created from that webprogram (done by the website maker) using FTP but could gain a lot if we could directly access the data on the website. ADS could do that; however we would have to arrange that the webprogrammer exports to DBF instead of csv so we can access the data. Is there (a better?) recommended way to directly read MySQL data on websites? Dick
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Access MySQL files directly on internet sites D.J.W. van Kooten <public@ic2remove.this.com> - 2011-06-07 11:24 +0200
Re: Access MySQL files directly on internet sites Johan Nel <johan.nel@xsinet.co.za> - 2011-06-07 04:00 -0700
Re: Access MySQL files directly on internet sites "Willie Moore" <williem@wmconsulting.com> - 2011-06-07 07:24 -0500
Re: Access MySQL files directly on internet sites "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-06-07 22:16 +0000
Re: Access MySQL files directly on internet sites D.J.W. van Kooten <public@ic2remove.this.com> - 2011-06-10 11:45 +0200
Re: Access MySQL files directly on internet sites "Apolonio Luis M." <apolonioluis@gmail.com> - 2011-06-14 23:40 -0700
csiph-web