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

[Stephen Leake <stephen_leake@acm.org>]

Gautier <gautier@fakeaddress.nil> writes:

> 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) ?

http://sourceforge.net/projects/gnade

GNADE works on Windows. I use it to access MySQL thru ODBC; it should
work for MS SQL thru ODBC as well. I haven't tried it with GNAT GPL
edition; if you encounter compilation errors, I can clean them up.

> The Ada code would steer DBs through simple SQL queries.
> It also would call stored procedures - are these MS-specific ?

I don't see that it matters whether the stored procedures are
MS-specific; you call them via SQL, don't you?

> I would use GNAT from the Ada side but I would prefer a
> compiler-independent solution, if it exists.

GNADE has some GNAT dependencies, but they should be easy to get rid
of if you really want to.

> The aim is to re-engineer progressively a crappy VB.Net program.

VB has a lot of slick user interface stuff that is totally lacking in
GNADE. For that you can try GtkAda or GWindows.

-- 
-- Stephe