# MS SQL Server connection via Ruby

**URL:** <https://www.ruby-forum.com/t/ms-sql-server-connection-via-ruby/116852>\
**Category:** Ruby\
**Created:** [October 10, 2007, 12:31pm UTC](https://www.ruby-forum.com/t/ms-sql-server-connection-via-ruby/116852 "2007-10-10T12:31:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![drlelon](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ee59a6/32.png) [@drlelon](https://www.ruby-forum.com/u/drlelon)\
**Post date:** [October 10, 2007, 12:31pm UTC](https://www.ruby-forum.com/t/ms-sql-server-connection-via-ruby/116852/1 "2007-10-10T12:31:52Z")

</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?

def test\_connection  
begin  
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”]}”  
)  
is\_connected  
rescue DBI::DatabaseError =\> e  
puts “Error #{e.errstr}”  
rollback  
ensure  
#disconnect from server  
disconnect  
end  
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) from /usr/lib/ruby/site_ruby/1.8/dbi/dbi.rb:401:in`\_get\_full\_driver’  
from /usr/lib/ruby/site\_ruby/1.8/dbi/dbi.rb:381:in `connect' from ./database_adapter.rb:77:in`connect’  
from ./database\_adapter.rb:65:in `test_connection' from ./game_adapter.rb:6:in`initialize’  
from ./ballerium/ballerium\_adapter.rb:6:in `initialize' from ./game_adapter_factory.rb:14:in`new’  
from ./game\_adapter\_factory.rb:14:in `get\_adapter’  
from test.rb:11

---

<div class="post-metadata">

**Author:** ![drlelon](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ee59a6/32.png) [@drlelon](https://www.ruby-forum.com/u/drlelon)\
**Post date:** [October 10, 2007, 1:01pm UTC](https://www.ruby-forum.com/t/ms-sql-server-connection-via-ruby/116852/2 "2007-10-10T13:01:21Z")

</div>

David L. 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](http://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