From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=ham autolearn_force=no version=3.4.4 X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 103376,fdd25d716dcc6842 X-Google-Attributes: gid103376,public X-Google-ArrivalTime: 2004-01-28 07:03:19 PST Path: archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news2.telebyte.nl!teleglobe.net!teleglobe.net!62.81.31.29.MISMATCH!cyclone.auna.com!twister.auna.com!53ab2750!not-for-mail From: Jano Newsgroups: comp.lang.ada Subject: Re: MS Access Message-ID: References: <40170BE6.B765CC9A@hiwaay.net> <543f109ckvl8nmkt8oppcsn70mro6k4pip@4ax.com> X-Newsreader: MicroPlanet Gravity v2.50 Date: Wed, 28 Jan 2004 16:03:10 +0100 NNTP-Posting-Host: 212.97.177.27 X-Trace: twister.auna.com 1075302197 212.97.177.27 (Wed, 28 Jan 2004 16:03:17 MET) NNTP-Posting-Date: Wed, 28 Jan 2004 16:03:17 MET Organization: AUNA TLC Xref: archiver1.google.com comp.lang.ada:5000 Date: 2004-01-28T16:03:10+01:00 List-Id: Dmitry A. Kazakov dice... > On 27 Jan 2004 21:58:12 -0500, Stephen Leake > wrote: > > >Lorrie Hellier writes: > > > >> Has anyone had any success interfacing to a microsoft access database > >> via Ada? Would appreciate any help. > > > >I have not. But I think there is an ODBC interface to MS Access, and > >GNADE (http://sourceforge.net/projects/gnade) has a decent binding to > >ODBC, which I have used on Windows (to access a MySQL database). > > I had both MySQL and MS Access 2002, ODBC in GNADE worked fine. I use GNADE to MSAccess via ODBC. I have problems inserting records, because some cursor is left open and I must disconnect after each insertion, but it works. I suspect of a failure in gesql (the embedded SQL translator), but I may be wrong.