# ODBC to MSSQL - how?

**URL:** <https://www.ruby-forum.com/t/odbc-to-mssql-how/126513>\
**Category:** Rails\
**Created:** [January 18, 2008, 10:17pm UTC](https://www.ruby-forum.com/t/odbc-to-mssql-how/126513 "2008-01-18T22:17:47Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sithadmin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/858c86/32.png) [@sithadmin](https://www.ruby-forum.com/u/sithadmin)\
**Post date:** [January 18, 2008, 10:17pm UTC](https://www.ruby-forum.com/t/odbc-to-mssql-how/126513/1 "2008-01-18T22:17:47Z")

</div>

Hello,  
I am running an app with InstantRails v1.6 on Windows Server 2003 (IIS6  
is turned off, I’m running on Apache w/ MySQL), and I have an ODBC  
connection setup with “administrative tools \> data sources (ODBC)” to an  
MSSQL db on another machine. How can I connect to that in addition to  
the MySQL db from my RoR app? I only want to read from that DB, no  
writing involved. I haven’t used ODBC before, so any help is  
appreciated!

Thanks,

- Jeff