From: Tom Ward <tom@...>
Date: 2006-10-21T00:12:07+09:00
Subject: Re: MsSqlClient ActiveRecord Adapter initial gem-release!

On 19/10/06, Sam Smoot <ssmoot@gmail.com> wrote:
> First gem-release of the MsSqlClient. MsSqlClient is an ActiveRecord
> Database Adapter for Win32 systems connecting to Microsoft SQL Server
> (2000, 2005 [Express]).
>
> It's much faster than the DBI adapter, and more importantly, has full
> support for Unicode NVARCHAR to UTF8 translation to and from the
> database!

It's great you're working on improving the connectivity between rails
and MS SQL.  While I don't know of many issues with the ODBC
connectivity, the ADO DBI interface is ripe for improvement.

It looks like most of the work you've put in is in implementating the
ms_sql_client.dll.  While the adapter code you're using is slightly
modified, it's not significantly changed from that in the main SQL
Server adapter (which uses DBI to connect, either through ADO or
ODBC).  Is there any reason you couldn't adapt this to provide a new
DBI driver which would work seamlessly with the current
sqlserver_adapter code?  If there are reasons, are there any changes
that could be made to the sqlserver_adapter so it could easily work
with both DBI and your interface?

Tom