Re: Databases and Ada95

[Sune.Falck@swipnet.se (Sune Falck)]

In article <cXDm4.953$rH3.1395@newsfeed.slurp.net>, 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