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!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed-east.nntpserver.com!nntpserver.com!statler.nntpserver.com!newsfeed.media.kyoto-u.ac.jp!Spring.edu.tw!news.nctu.edu.tw!feeder.seed.net.tw!netnews!not-for-mail
From: "news.hinet.net" <bubble@riskm.com.tw>
Newsgroups: comp.lang.ada
Subject: Re: Open-source to access MS SQL server 2000/2005 DBs from Ada ?
Date: Mon, 3 Apr 2006 11:27:02 +0800
Organization: HiNetNews
Message-ID: <e0q4mg$rn4$1@netnews.hinet.net>
References: <442afe28_1@news.bluewin.ch>
NNTP-Posting-Host: 211-21-128-195.hinet-ip.hinet.net
X-Trace: netnews.hinet.net 1144034833 28388 211.21.128.195 (3 Apr 2006
 03:27:13 GMT)
X-Complaints-To: usenet@HiNetnews.hinet.net
NNTP-Posting-Date: Mon, 3 Apr 2006 03:27:13 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
Xref: g2news1.google.com comp.lang.ada:3711
Date: 2006-04-03T11:27:02+08:00
List-Id: <comp.lang.ada>

I have expereniced do it with sql 2000/2005 in gnatcom.
use ADO to access MS's database is no problem.
if you want re-engineer .NET code.
be careful,
the ADO .NET programming model is very different to ADO model.
It mean you need some adjust.

and
the ADO to access SQL2005 sometime is slower than SQL native client does.
the ADO access SQL2005 still need .NET framework and SQL native client.
if performance is import to you , consider A# and .NET framework.

if you need sample code,write mail to me.
b u b b l e @ r i s k m . c o m . t w , I  will mail it to you.