Forum: Ruby on Rails Problems Connecting to SQL Server

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
A7db9ec803b5895ae5f916a74e2db329?d=identicon&s=25 HH (Guest)
on 2006-02-15 18:10
(Received via mailing list)
I've been asked to make my app work on Windows Server 2003 and connect
to
SQL Server. I'm having trouble getting connected to SQL Server. It fails
as
follows:

is not a class/module

C:\InstantRails-1.0\ruby\lib\ruby\site_ruby\1.8\dbi\dbi.rb:499 in
'load_driver'

So, I went through the instructions on the Rails/MSSQL page. I installed
the
ADO.rb stuff.

Also, require "dbi" comes back true.

Still no dice.

I did some Googling and while the term comes up, I couldn't find a
solution.

Any other ideas for troubleshooting this stuff?

Thanks.
H
413faf211358af7cae68c1f2137de0f8?d=identicon&s=25 Mel Riffe (Guest)
on 2006-02-15 20:00
(Received via mailing list)
HH (and other interested readers)

I've attached a file I use to test connections to the SQL Server
databases I
need to access.  It's a plain ruby file so running it should give you a
helpful error message if a connection can't be made.

It sounds like you've done the necessary legwork to get the connection
going; I followed the same page you did.

HTH

Mel
413faf211358af7cae68c1f2137de0f8?d=identicon&s=25 Mel Riffe (Guest)
on 2006-02-15 20:03
(Received via mailing list)
DOH! - the second connection string takes an ODBC datasource name you
define
- I forget to mark that with double <>
This topic is locked and can not be replied to.