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-Thread: 103376,b26adfb3d6ee3dbd
X-Google-Attributes: gid103376,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Sun, 16 Apr 2006 20:00:48 +0200
From: Gautier <gautier@fakeaddress.nil>
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
Newsgroups: comp.lang.ada
Subject: Re: Q: Open-source to access MS SQL server 2000/2005 DBs from Ada
 ?
References: <442afe28_1@news.bluewin.ch> <6k6g0e.rr5.ln@hunter.axlog.fr>
In-Reply-To: <6k6g0e.rr5.ln@hunter.axlog.fr>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 62.202.55.188
X-Original-NNTP-Posting-Host: 62.202.55.188
Message-ID: <4442866d$1_2@news.bluewin.ch>
X-Trace: news.bluewin.ch 1145210477 62.202.55.188 (16 Apr 2006 20:01:17 +0200)
Organization: Bluewin AG
Complaints-To: abuse@bluewin.ch
X-Original-NNTP-Posting-Host: 127.0.0.1
Path: 
 g2news1.google.com!news3.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!t-online.de!130.59.10.21.MISMATCH!kanaga.switch.ch!news-zh.switch.ch!switch.ch!news.ip-plus.net!newsfeed.ip-plus.net!news.bluewin.ch!not-for-mail
Xref: g2news1.google.com comp.lang.ada:3841
Date: 2006-04-16T20:00:48+02:00
List-Id: <comp.lang.ada>

Jean-Pierre Rosen:

>> What do you recommend as an open-source, reliable package (or set
>> of packages) to access MS SQL server 2000/2005 DBs (hopefully these
>> versions are not of importance) ?
> I would recommend ODBC, this makes the *binding* independent from any 
> DBMS.

Thank you - at a first glance that solution would at best fit
my needs, even though I will evaluate other(s) - at least GNADE.
If it is lightweight and not necessarily GNAT-dependent it would be
perfect.

 > Of course, the *queries* would depend on the DBMS, but it is easy
> to localize these dependencies.

There is also an Oracle DB to grab into, so I will be happy with a
multi-DBMS solution.

>> The Ada code would steer DBs through simple SQL queries.
>> It also would call stored procedures - are these MS-specific ?
>>
> Stored procedures could be a problem, especially if you want to keep 
> some portability. Can't you do the equivalent on the Ada side?

Indeed yes, and I will do it that way, especially because the
[sort of] language for stored procedures is very limited and clumsy enough.

Thank you also to everybody who helped me in that topic!
_______________________________________________________________
Gautier         -- http://www.mysunrise.ch/users/gdm/index.htm
Ada programming -- http://www.mysunrise.ch/users/gdm/gsoft.htm

NB: For a direct answer, e-mail address on the Web site!