Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #1277 > unrolled thread
| Started by | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| First post | 2011-06-07 11:24 +0200 |
| Last post | 2011-06-14 23:40 -0700 |
| Articles | 6 — 5 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2011-06-07 11:24 +0200 |
| Subject | Access 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]
| From | Johan Nel <johan.nel@xsinet.co.za> |
|---|---|
| Date | 2011-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]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2011-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]
| From | "Geoff Schaller" <geoffx@softwarexobjectives.com.au> |
|---|---|
| Date | 2011-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]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2011-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]
| From | "Apolonio Luis M." <apolonioluis@gmail.com> |
|---|---|
| Date | 2011-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