[ruby-dbi-users] Cannot connect to MSSQL from Windows7(64bit)

Pardee, Roy pardee.r at ghc.org
Thu Feb 25 16:01:21 EST 2010

This is probably silly, but...  Do you have the ADO driver file?  I believe that would be located at:


If you're using the old one-click installer, you won't get that file by default--got to d/l it separate.



-----Original Message-----
From: ruby-dbi-users-bounces at rubyforge.org [mailto:ruby-dbi-users-bounces at rubyforge.org] On Behalf Of yuichi fujiki
Sent: Thursday, February 25, 2010 12:02 PM
To: ruby-dbi-users at rubyforge.org
Subject: [ruby-dbi-users] Cannot connect to MSSQL from Windows7(64bit)

Hello, I am having trouble connecting to MSSQL Server from 64bit Windows7.
I have been using Windows XP as a client before and the following connection code worked just fine.

> require 'dbi'
> DBI.connect('DBI:ADO:Provider=SQLOLEDB;Data Source=hostname;Initial
> Catalog=dbname;User Id=user;Password=pass')

But on 64bit Windows7 I purchased recently, it throws following error.

DBI::InterfaceError: Could not load driver (uninitialized constant
from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:318:in 'load_driver'
from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:160:in '_get_full_driver'
from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:145:in 'connect'
from (irb):3
from :0

I googled around, but I didn't find anybody who had the same error.
Can anybody help me out?

ruby-dbi-users mailing list
ruby-dbi-users at rubyforge.org

GHC Confidentiality Statement

This message and any attached files might contain confidential information protected by federal and state law. The information is intended only for the use of the individual(s) or entities originally named as addressees. The improper disclosure of such information may be subject to civil or criminal penalties. If this message reached you in error, please contact the sender and destroy this message. Disclosing, copying, forwarding, or distributing the information by unauthorized individuals or entities is strictly prohibited by law.

More information about the ruby-dbi-users mailing list