From: "Clinton D. Judy" <cdj@...>
Date: 2008-09-04T21:20:51+09:00
Subject: Connecting to SQL Server

------_=_NextPart_001_01C90E89.75149DE6
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

So ActiveRecord has failed me. The sqlserver module isn't complete, and
I'm getting "zombie state" errors, essentially because Rails wants to
maintain a connection to SQL server and SQL server is used to ASP.net
making connections to the server for every request. (Yuck, but that's
what I have to work with here.) Is there a ruby gem that's been
maintained to use SQL Server better? I can't find one, but someone's
gotta be working on one with how common SQL Server is.

=20

I don't even use most of the "cool" features ActiveRecord has as I have
a DBA here who insists on using stored procedures for everything. That's
an industry standard, but not the Rails way, and thus another roadblock
in my Rails application.

=20

If there isn't anything, I'll research creating my own gem to do the
task. Obviously I'd rather not duplicate efforts. Thanks!

=20

Clinton Judy

Web Developer

Glenn O. Hawbaker, Inc.

=20


------_=_NextPart_001_01C90E89.75149DE6--