# MS SQL Server connection via Ruby

**URL:** <https://rubytalk.org/t/ms-sql-server-connection-via-ruby/41287>\
**Category:** ruby-talk\
**Created:** [10 October 2007 10:31 UTC](https://rubytalk.org/t/ms-sql-server-connection-via-ruby/41287 "2007-10-10T10:31:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![David\_Lee1](https://avatars.discourse-cdn.com/v4/letter/d/bc8723/32.png) [@David\_Lee1](https://rubytalk.org/u/David_Lee1)\
**Post date:** [10 October 2007 10:31 UTC](https://rubytalk.org/t/ms-sql-server-connection-via-ruby/41287/1 "2007-10-10T10:31:56Z")

</div>

I am running Ruby on Fedora Core 6 and I am running into problems I do  
not see on my windows box. Any help would be awesome - its been 2 days  
I tried everything and even installed unixODBC and that worked but  
installing freeTDS ha problems. Can someone guide me into getting this  
to work?

&nbsp;&nbsp;def test\_connection  
&nbsp;&nbsp;&nbsp;&nbsp;begin  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;connect( "DBI:ODBC:Driver={SQL  
Server};Server=#{@adapter\_config["acct\_db\_host"]};Database=#{@adapter\_config["acct\_db\_name"]};Uid=#{@adapter\_config["acct\_db\_user"]};Pwd=#{@adapter\_config["acct\_db\_pass"]}"  
)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;is\_connected  
&nbsp;&nbsp;&nbsp;&nbsp;rescue DBI::DatabaseError =\> e  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;puts "Error #{e.errstr}"  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rollback  
&nbsp;&nbsp;&nbsp;&nbsp;ensure  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#disconnect from server  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;disconnect  
&nbsp;&nbsp;&nbsp;&nbsp;end  
&nbsp;&nbsp;end

/usr/lib/ruby/site\_ruby/1.8/dbi/dbi.rb:511:in `load\_driver': Could not  
load driver (no such file to load -- odbc) (DBI::InterfaceError)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;from /usr/lib/ruby/site\_ruby/1.8/dbi/dbi.rb:401:in  
`\_get\_full\_driver'  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;from /usr/lib/ruby/site\_ruby/1.8/dbi/dbi.rb:381:in `connect'  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;from ./database\_adapter.rb:77:in `connect'  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;from ./database\_adapter.rb:65:in `test\_connection'  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;from ./game\_adapter.rb:6:in `initialize'  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;from ./ballerium/ballerium\_adapter.rb:6:in `initialize'  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;from ./game\_adapter\_factory.rb:14:in `new'  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;from ./game\_adapter\_factory.rb:14:in `get\_adapter'  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;from test.rb:11

> **···**
>
> --  
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).

---

<div class="post-metadata">

**Author:** ![Damjan\_Rems](https://avatars.discourse-cdn.com/v4/letter/d/65b543/32.png) [@Damjan\_Rems](https://rubytalk.org/u/Damjan_Rems)\
**Post date:** [10 October 2007 11:01 UTC](https://rubytalk.org/t/ms-sql-server-connection-via-ruby/41287/2 "2007-10-10T11:01:23Z")

</div>

David Lee wrote:

> I am running Ruby on Fedora Core 6 and I am running into problems I do  
> not see on my windows box. Any help would be awesome - its been 2 days  
> I tried everything and even installed unixODBC and that worked but  
> installing freeTDS ha problems. Can someone guide me into getting this  
> to work?

I was able to install freetds on ubuntu 7.04. This is my /tmp/odbc.ini  
part.

[TESTSQL]  
Driver = FreeTDS  
Description = FreeTDS SQL Server ODBC driver  
Server = testsql.my.com  
Port = 1433  
Database = ruby  
User =  
Password =  
Mars\_Connection = No  
Logging = 0  
LogFile =  
QuotedId = Yes  
AnsiNPW = Yes  
Language =  
Version7 = No  
ClientLB = No  
Failover\_Partner =  
VarMaxAsLong = No

And am using DBI odbc driver.

require 'dbi'  
dbs = DBI.connect('DBI:ODBC:TESTSQL', 'usr', 'pwd')

It works with rails too, minus UTF-8 support. But that can be managed  
too.

by  
TheR

> **···**
>
> --  
> Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C).