Re: Q: Open-source to access MS SQL server 2000/2005 DBs from Ada ?

[Gautier <gautier@fakeaddress.nil>]

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!