From: gregarican Date: 2010-01-22T06:25:12+09:00 Subject: Re: Rails ADODB.Connection Error On Jan 21, 4:15 pm, Phillip Gawlowski wrote: > 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 Yeah, this is my first forway into the world of 64-bit Windows 2008 Server. I also had to port over roughly two dozen ODBC System DSN's and how some were only accessible through the 64-bit ODBC Manager and others through the 32-ODBC Manager was throwing me for a moment or two. From what I can tell the Rails SQLServer connector appears to be using SQLOLEDB, which Lord knows if it's looking for the wrong version or something. When I was able to use IRB on connect to the SQL 2008 Server database fine on the box I thought I had hope. But if behind the scenes Rails is using something different that's more hard-coded I might seek an alternative method of getting this migration done. Appreciate the insight!