Forum: Ruby on Rails Problems Connecting to SQL Server

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
HH (Guest)
on 2006-02-15 19:10
(Received via mailing list)
I've been asked to make my app work on Windows Server 2003 and connect
SQL Server. I'm having trouble getting connected to SQL Server. It fails

is not a class/module

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

So, I went through the instructions on the Rails/MSSQL page. I installed
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

Any other ideas for troubleshooting this stuff?

Mel R. (Guest)
on 2006-02-15 21: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.


Mel R. (Guest)
on 2006-02-15 21:03
(Received via mailing list)
DOH! - the second connection string takes an ODBC datasource name you
- I forget to mark that with double <>
This topic is locked and can not be replied to.