# Is SQL Server not supported in RoR on the Mac?

**URL:** <https://www.ruby-forum.com/t/is-sql-server-not-supported-in-ror-on-the-mac/130596>\
**Category:** Rails\
**Created:** [February 29, 2008, 5:49pm UTC](https://www.ruby-forum.com/t/is-sql-server-not-supported-in-ror-on-the-mac/130596 "2008-02-29T17:49:10Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![biot023](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/7ab992/32.png) [@biot023](https://www.ruby-forum.com/u/biot023)\
**Post date:** [February 29, 2008, 5:49pm UTC](https://www.ruby-forum.com/t/is-sql-server-not-supported-in-ror-on-the-mac/130596/1 "2008-02-29T17:49:10Z")

</div>

Hi – I’ve been having problems connecting to a SQL Server database that  
I thought might be related to the fact I was upgrading Rails to 2.0.  
However, I also was moving the project to my shiny new macbook.  
Anyway, after jumping through a few hoops (instaling DBI, etc.), I  
finally get to my latest error message:

DBI::InterfaceError: Could not load driver (no such file to load -- win32ole) from /usr/local/lib/ruby/site\_ruby/1.8/dbi.rb:344:in `load_driver' from /usr/local/lib/ruby/site_ruby/1.8/dbi.rb:227:in `\_get\_full\_driver' from /usr/local/lib/ruby/site\_ruby/1.8/dbi.rb:213:in `connect' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:46:in `sqlserver\_connection' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:291:in `send' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:291:in `connection=' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:259:in `retrieve_connection' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/base.rb:2438:in `quoted_table_name' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:1353:in `construct\_finder\_sql' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/base.rb:1233:in `find_every' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:1227:in `find\_initial' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/base.rb:502:in `find' from (irb):1

This seems to suggest that the SQL Server connection won’t work on my  
Mac, which also suggests that the Unix web server I’m wanting to build  
that will connect to  
the SQL Server database won’t either.  
Is this correct?  
Can anyone advise any workarounds, or maybe a place to start looking  
into fixing this?  
Cheers,  
Doug.

PS – I have no choice but to work with SQL Server.