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 Path: g2news1.google.com!news3.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newscon06.news.prodigy.com!prodigy.net!newspeer.monmouth.com!newsfeed.icl.net!newsfeed.fjserv.net!oleane.net!oleane!hunter.axlog.fr!nobody From: Jean-Pierre Rosen Newsgroups: comp.lang.ada Subject: Re: Q: Open-source to access MS SQL server 2000/2005 DBs from Ada ? Date: Thu, 30 Mar 2006 10:58:46 +0200 Organization: Adalog Message-ID: <6k6g0e.rr5.ln@hunter.axlog.fr> References: <442afe28_1@news.bluewin.ch> NNTP-Posting-Host: mailhost.axlog.fr Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Trace: s1.news.oleane.net 1143709265 28998 195.25.228.57 (30 Mar 2006 09:01:05 GMT) X-Complaints-To: abuse@oleane.net NNTP-Posting-Date: Thu, 30 Mar 2006 09:01:05 +0000 (UTC) User-Agent: Thunderbird 1.5 (Windows/20051201) In-Reply-To: <442afe28_1@news.bluewin.ch> Xref: g2news1.google.com comp.lang.ada:3684 Date: 2006-03-30T10:58:46+02:00 List-Id: Gautier a �crit : > 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. Of course, the *queries* would depend on the DBMS, but it is easy to localize these dependencies. > 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? -- --------------------------------------------------------- J-P. Rosen (rosen@adalog.fr) Visit Adalog's web site at http://www.adalog.fr