# Default Database with ODBC and SQL Server

**URL:** <https://www.ruby-forum.com/t/default-database-with-odbc-and-sql-server/147160>\
**Category:** Rails\
**Created:** [August 28, 2008, 10:49pm UTC](https://www.ruby-forum.com/t/default-database-with-odbc-and-sql-server/147160 "2008-08-28T22:49:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sjames](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/c57346/32.png) [@sjames](https://www.ruby-forum.com/u/sjames)\
**Post date:** [August 28, 2008, 10:49pm UTC](https://www.ruby-forum.com/t/default-database-with-odbc-and-sql-server/147160/1 "2008-08-28T22:49:29Z")

</div>

I’m trying to set up a Rails application to use an ODBC connection to  
a MS SQL Server 2005 system. I’m finding that if I don’t specify a  
default database the connection works, but if I do the connection  
fails. Does anyone know why this might be?

James