Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Wolfgang Riedmann" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: Cavo reads MySql Date: Sun, 7 Mar 2021 17:24:45 +0100 Lines: 48 Message-ID: References: <1066ca7c-6a84-4062-8daf-3a5af9ae5853n@googlegroups.com> <8ed36d65-4458-458e-ba77-c3d61d36af84n@googlegroups.com> <65fc41fa-16a3-4fed-8ccb-7f69479a2efcn@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 X-Trace: individual.net 8sN8P9oN8Ab4ZAtHpNnDwgvZBSi9SafUdvANzE75UhWrZNTJ8= Cancel-Lock: sha1:3ULbEUvbwkRmEahtQbuipJ4p/4Q= User-Agent: XanaNews/1.18.1.6 Xref: csiph.com comp.lang.clipper.visual-objects:13284 Hi Henry, please let me add a few things to what Franz wrote (I use a similar approach to access databases that have no public access): - you don't need any ODBC driver in that case - please beware that you have a public access to the database then. First, use a SSL connection, and second, protect the access with a password - since you don't need any ODBC driver, you don't have to configure anything on the client machines Every time when it comes to connections over the internet, security has to be the most important issue! Sometimes it may be better to build a webservice to interact with your internet application, maybe up- and downloading CSV, XML or JSON files (but always use password protection and SSL). Wolfgang Franz Rachbauer wrote: > Actual and previous ODBC Drivers for MySQL you can find here: > https://dev.mysql.com/downloads/connector/odbc/ > > Server Name ist the IP of the host where the MySQL DB is hostet, but > as Wolfgang already says: Providers do not permit external access to > their DB hosts! So I always use small PHP apps at the providers host, > which get the request by url, read the db and get back the result. > > Franz > > Am 05.03.2021 um 20:36 schrieb Henry Fidler: > > Wolfgang thanks for your answer > > > > 1. Driver: Where do I find the driver for MySQL ? > > 2. Server: How do I find the server name? (is it the URL?) > > > > Thanks > > Henry > > --