Re: Differences in data description in programming languages

From: Alistair Maclean (alistair_at_ld50macca.demon.co.uk)
Date: 11/28/04


Date: 28 Nov 2004 08:16:30 -0800

Well said.

"Pete Dashwood" <dashwood@enternet.co.nz> wrote in message news:<30tjpoF33o8q1U1@uni-berlin.de>...
> In passing I'd like to note an exception.
>
> I recently had cause to develop an application that needed to have a shared
> (via the Internet) database. I found an ISP who would allow my MS ACCESS DB
> to be shared on his server, using the MyODBC driver for remote access and
> managing it with MySQL server (which can also accomodate ACCESS DBs...). I
> was impressed with MyODBC which worked exactly as documented and implemented
> facilities that MS ODBC SHOULD have had. It allowed me to define the remote
> DB as a DSN and even gave me a facility to test the connection at the same
> time.
>
> MyODBC is Open Source and a free download.
>
> My PowerCOBOL application didn't mind it at all and ran correctly, going via
> this driver to the remote ACCESS DB in under 5 seconds. (A round trip of
> 15000 miles). Subsequent accesses were under 3 seconds. Pretty good for free
> software.
>
> I was so intriqued, I decided to convert the ACCESS database to MySQL which
> was a very simple process. To my astonishment, I found that MySQL had all
> the facilities of ACCESS (although it took a few days to get round the
> learning curves) and ran much faster! Running it on the same server the
> initial response was under 4 seconds and subsequent under 2. All of my
> existing SQL ran without change (apart from one complex piece of nested SQL,
> which I simply broke into simpler statements).
>
> MySQL is Open Source and a free download.
>
> These products are stable, supported, and in use all over the world by
> hundreds of thousands of people.
>
> So it would be unfair to classify all Open Source as "Mickey Mouse"... I
> have decided to use MySQL for all future development and have found the
> support forums and the products and documentation to be first class.
>
> It would be great to see TC doing the same, but I fear it is not likely...
>
> Pete.



Relevant Pages

  • Re: Wie kann ich ohne ODBC auf MySQL zugreifen?
    ... die Daten auf MySQL schreibt/liest. ... ist nun mal, MyODBC zu installieren. ... Das geht zwar über 2 Ecken und ist deshalb ... Wenn Du MyODBC installiert hast, ...
    (microsoft.public.de.german.scripting.wsh)
  • Re: Access und SQL-Server/MySQL
    ... Das kommt auf die Einstellungen des ODBC-Treibers an und gerade für ACC ... > von Access und SQL-Server bzw. MySQL? ... Die Zuordnung Zahl zu Bedeutung steht in der Hilfe zu MyODBC. ...
    (microsoft.public.de.access.clientserver)
  • Error for Linked ODBC tables
    ... I have connected MS Access to MySQL 5.0.17 with MyODBC 3.51.12 with MS ... Jet SP 8. ... It is giving error -7776 (There is no message for this ...
    (comp.databases.ms-access)
  • Re: VFP8/wine
    ... > Das wird aber dann eher ein Thema von MySQL oder dem MyODBC sein, ... > Wieso verwendet ihr ?berhaupt MySQL, wenn ihr SubSelects und andere ... > PostgreSQL die weitaus bessere Datenbank unter Linux als MySQL... ...
    (microsoft.public.de.fox)
  • Re: Differences in data description in programming languages
    ... I decided to convert the ACCESS database to MySQL which ... I found that MySQL had all ... > MySQL is Open Source and a free download. ... > support forums and the products and documentation to be first class. ...
    (comp.lang.cobol)