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
Path: 
 g2news1.google.com!news3.google.com!news.glorb.com!atl-c08.usenetserver.com!news.usenetserver.com!pc03.usenetserver.com!news.flashnewsgroups.com-b7.4zTQh5tI3A!not-for-mail
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>
From: Stephen Leake <stephen_leake@acm.org>
Date: Thu, 30 Mar 2006 21:32:30 -0500
Message-ID: <usloz1gzl.fsf@acm.org>
User-Agent: Gnus/5.1006 (Gnus v5.10.6) Emacs/21.3 (windows-nt)
Cancel-Lock: sha1:dgk8/i9Wd1e9oLTno7wmKjiMQ+Q=
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: abuse@flashnewsgroups.com
Organization: FlashNewsgroups.com
X-Trace: 6ee38442c94c3e73ae4a414608
Xref: g2news1.google.com comp.lang.ada:3688
Date: 2006-03-30T21:32:30-05:00
List-Id: <comp.lang.ada>

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