From: Luis Lavena <luislavena@...>
Date: 2010-01-22T05:25:07+09:00
Subject: Re: Rails ADODB.Connection Error

On Jan 21, 2:03 pm, gregarican <greg.kuj...@gmail.com> wrote:
> I know this isn't exclusively a Rails list, so I apologize in advance.
> Since this is the main list I work with I hope someone might have some
> insight into a particularly nagging error message I have been getting.
>
> The scenario is I have to move a working Rails setup to a new server.
> So I installed Ruby/Rails/Apache/FastCGI on the new server as well as
> a SQL Server instance. Then I copied over the Rails application
> directory to the new box. Figuring that pointing Rails to the new SQL
> Server instance would just involve modifying the database.yml file, I
> changed the host name to the new SQL Server instance.
>
> I can get the default Rails welcome page fine on the new server. But
> when I try to launch my Rails app I get the error below. Any
> suggestions about what specifically is the issue? Using IRB I can open
> up the new SQL Server instance and query its Employee table fine on
> the new server (which is what my Rails app is doing below).
>
> DBI::DatabaseError in Employee#signIn
>
> failed to create WIN32OLE object from `ADODB.Connection'
>     HRESULT error code:0x8007007e
>       The specified module could not be found.
> app/controllers/employee_controller.rb:111:in `signIn'
>
> Show framework trace
>

Basically Win32OLE, the backend used to connect using SQLServer, is
telling you that cannot find ADODB.Connection module

Most likely, you don't have ADODB installed in your computer.

Searching google for HRESULT 0x8007007e indicates that maybe a missing
DLL or a DLL used by it.

Please ensure SQLServer and required libraries installed properly.

--
Luis Lavena