From: Phillip Gawlowski <pg@...>
Date: 2010-01-22T06:15:52+09:00
Subject: Re: Rails ADODB.Connection Error

On 21.01.2010 22:00, gregarican wrote:

> Wonder if it's something about the new box being 64-bit Windows Server
> 2008? This is something I didn't thoroughly research in advance due to
> being forced to pull the trigger quicker than I'd have liked. The
> Rails version is _ancient_ too. From 2005 I believe. Version 0.12.0
> IIRC :-/

Yeah, the 64 bit issue seems the big one. And if you have a SQL Server 
2008 instance, I doubt the ActiveRecord connectors from 2005 can talk to 
it, so you have two problems for the price of one. ;)

The Ruby issues, you could, possibly, fix by using a 64 bit build of 
Ruby (no clue if such a thing is available, however). A more recent 
Rails should come with SQL Server 2008 support if you need that, 
otherwise you have to somehow proxy the DB requests through an SQL 
Server instance that your ActiveRecord can connect to.

--
Phillip Gawlowski