Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #1280

Re: Access MySQL files directly on internet sites

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>

Show all headers | View raw


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


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