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.3 required=5.0 tests=BAYES_00,INVALID_MSGID autolearn=no autolearn_force=no version=3.4.4 X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 103376,9c5be310aaba832e X-Google-Attributes: gid103376,public From: Sune.Falck@swipnet.se (Sune Falck) Subject: Re: Databases and Ada95 Date: 2000/02/04 Message-ID: <7NFm4.5375$jg4.10574@nntpserver.swip.net>#1/1 X-Deja-AN: 581630598 References: X-Complaints-To: news-abuse@swip.net X-Trace: nntpserver.swip.net 949692611 212.151.164.32 (Fri, 04 Feb 2000 20:30:11 MET DST) Organization: A Customer of Tele2 Keywords: SAMEDL ADASAME SQL NNTP-Posting-Date: Fri, 04 Feb 2000 20:30:11 MET DST Newsgroups: comp.lang.ada Date: 2000-02-04T00:00:00+00:00 List-Id: In article , cts@kampong.aedinc.net (Craig Spannring) wrote: > >I'm kind of in the dark about accessing databases from Ada95. >I've seen mention of SAME and SAMEDL, but I can't seem to locate any >documentation about those. Does anyone actually use/support those? > >Unless something else pops It looks like my options are > 1) Use thin bindings to whatever C library the DB vendor supplies. > 2) Write thick bindings to the vendor supplied C library. > 3) Use thin bindings to ODBC. > 4) Use Pascal Obry's bindings to ODBC. > >The 3rd and 4th choices only work for MS-Windows. Choice 1 means my >code would be specific to one RDBMS not to mention messy. Choice 2 > It is possible to use odbc as an interface to databases on Unix systems. Take a look at www.iodbc.org which has a free implentation of an odbc driver manager for unix. I built a thin building to iodbc and have been able to access PostgreSQL on Solaris and Linux and Mimer (http://www.mimer.se/) on Linux through the binding. A slightly modified versions of the same binding (change of C to Stdcall in pragma import) can be used for win32 MS Windows. Some (all ?) databases with an odbc interface does not need the odbc driver but can be accessed directly with odbc calls. Sune Falck