# Setting up Ruby for use with MS SQL 2008

**URL:** <https://www.ruby-forum.com/t/setting-up-ruby-for-use-with-ms-sql-2008/175171>\
**Category:** Rails\
**Created:** [September 9, 2009, 9:38am UTC](https://www.ruby-forum.com/t/setting-up-ruby-for-use-with-ms-sql-2008/175171 "2009-09-09T09:38:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gavtheman](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/f9ae1b/32.png) [@Gavtheman](https://www.ruby-forum.com/u/Gavtheman)\
**Post date:** [September 9, 2009, 9:38am UTC](https://www.ruby-forum.com/t/setting-up-ruby-for-use-with-ms-sql-2008/175171/1 "2009-09-09T09:38:20Z")

</div>

Hello there!  
I am pretty close to being able to develop in rails, but I keep  
running into a problem with my setup in connecting to my MS SQL  
database. When I try to navigate to my control page, I get the “…but  
something went wrong” page. In the dev log I get the following error:  
Unable to load driver ‘ADO’ (underlying error: uninitialized  
constant DBI::DBD::ADO)  
I have configured my database.yml file correctly with:

development:  
adapter: sqlserver  
host: GAV64  
username: gavlogin  
database: helloworld\_development  
password: mmmfet$$1

I have also followed the install instructions at

> **[Rails SQL Server](https://github.com/rails-sqlserver/)**
>
> Rails SQL Server has 9 repositories available. Follow their code on GitHub.

in the install package, but still to no avail. I have also copied the  
ADO.rb file into the C:\Ruby\lib\ruby\site\_ruby\1.8\DBD\ADO directory.  
I think iv had a reasonable stab at getting it going myself, but I  
think I now need some new suggestions!  
I am running Vista64 with MS SQL 2008 64 bit edition. Any help is  
appreciated!