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


Groups > comp.lang.clipper.visual-objects > #1277 > unrolled thread

Access MySQL files directly on internet sites

Started byD.J.W. van Kooten <public@ic2remove.this.com>
First post2011-06-07 11:24 +0200
Last post2011-06-14 23:40 -0700
Articles 6 — 5 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#1277 — Access MySQL files directly on internet sites

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2011-06-07 11:24 +0200
SubjectAccess MySQL files directly on internet sites
Message-ID<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

[toc] | [next] | [standalone]


#1278

FromJohan Nel <johan.nel@xsinet.co.za>
Date2011-06-07 04:00 -0700
Message-ID<09278f80-93f2-4736-9a7b-3cd189ffbd72@m40g2000vbt.googlegroups.com>
In reply to#1277
Dick,

Any SQL driver could be used to do that, the MySQL database should
just allow remote access over the internet, given you have a valid
logon/password.

I have a similar situation with a remote PostgreSQL database that I
access over the internet directly from my desktop application.

Regards,

Johan Nel
Pretoria, South Africa.

On Jun 7, 11:24 am, D.J.W. van Kooten <pub...@ic2remove.this.com>
wrote:
> 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

[toc] | [prev] | [next] | [standalone]


#1280

From"Willie Moore" <williem@wmconsulting.com>
Date2011-06-07 07:24 -0500
Message-ID<isl59q$kan$1@speranza.aioe.org>
In reply to#1277
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 

[toc] | [prev] | [next] | [standalone]


#1289

From"Geoff Schaller" <geoffx@softwarexobjectives.com.au>
Date2011-06-07 22:16 +0000
Message-ID<4deea34f$0$12373$c30e37c6@exi-reader.telstra.net>
In reply to#1277
Dick.

This is not easy, not because it is mySQL but because the sql server is 
sitting on a web site. You could easily read the server remotely (using 
VO2ADO for example with a mySQL OLEDB provider) but rarely is remote 
access to a server like that possible from a web site. I doubt the ISP 
would allow it - but if they do then it is possible.

A better solution is to have a small web service on the web server that 
reads and feeds the data for you. That way you become independent of the 
ISP and of access rights. The web service thus only needs to be a very 
thin wrapper over sql statements to the mySQL server. You will have to 
receive the XML data responses but from VO, this is reasonably easy to 
deal with.

Geoff



"D.J.W. van Kooten" <public@ic2remove.this.com> 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

[toc] | [prev] | [next] | [standalone]


#1345

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2011-06-10 11:45 +0200
Message-ID<kpp3v69bgg5jmonbsanogckv6ngh51nfn1@4ax.com>
In reply to#1289
On Tue, 7 Jun 2011 22:16:47 +0000, "Geoff Schaller"
<geoffx@softwarexobjectives.com.au> wrote:

>Dick.
>
>This is not easy, not because it is mySQL but because the sql server is 
>sitting on a web site. 

Thanks Geoff, Willie & Johan for the remarks. I already though this to
be possible but difficult.

The client has indicated they are prepared to have ADS installed on
the webserver. The advantage is (hence the name <g>) that the database
can be approached through PHP so their web program needs minimal
changes, while I should be able to access the data from the
PC/servers, which is a supported ADS feature anway.

Dick

[toc] | [prev] | [next] | [standalone]


#1408

From"Apolonio Luis M." <apolonioluis@gmail.com>
Date2011-06-14 23:40 -0700
Message-ID<afb3fc28-b320-4976-9d95-2262f153821f@e35g2000yqc.googlegroups.com>
In reply to#1345
hello,

I have more than 5 years using mysql remotely.

Before using shared hosting.

Now I use vps. In both cases I can do remote access.

For remote access you should only use the remote ip or domain.

In the mysql server you just create a user account with permissions to
a certain remote ip or use % to indicate access from anywhere this can
be done very easily with cPanel or similar software.

Apolonio Luis Medina
Sonora, México.

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web