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

yuichi fujiki fjk89025 at gmail.com
Thu Feb 25 16:24:07 EST 2010


Roy,


Thank you for reply.

Yes, I have the ADO driver. Before installing the ADO, I received the error
"Uninitialized constant DBD:ADO" or something like that.
After adding it, it complaints about DBI:SQL:BasicBind as in my previous post.


Thank you,

Yuichi

On Thu, Feb 25, 2010 at 3:01 PM, Pardee, Roy <pardee.r at ghc.org> wrote:
> This is probably silly, but...  Do you have the ADO driver file?  I believe that would be located at:
>
> c:\ruby\lib\ruby\site_ruby\1.8\DBD\ADO\ado.rb
>
> If you're using the old one-click installer, you won't get that file by default--got to d/l it separate.
>
> HTH,
>
> -Roy
>
> -----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
> DBI::SQL::BasicBind)
> 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?
>
>
> Yuichi
> _______________________________________________
> ruby-dbi-users mailing list
> ruby-dbi-users at rubyforge.org
> http://rubyforge.org/mailman/listinfo/ruby-dbi-users
>
> 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.
> _______________________________________________
> ruby-dbi-users mailing list
> ruby-dbi-users at rubyforge.org
> http://rubyforge.org/mailman/listinfo/ruby-dbi-users
>


More information about the ruby-dbi-users mailing list