# MS SQL direct access

**URL:** <https://www.ruby-forum.com/t/ms-sql-direct-access/75587>\
**Category:** Ruby\
**Created:** [November 11, 2006, 3:16am UTC](https://www.ruby-forum.com/t/ms-sql-direct-access/75587 "2006-11-11T03:16:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![johnf](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/848f3c/32.png) [@johnf](https://www.ruby-forum.com/u/johnf)\
**Post date:** [November 11, 2006, 3:16am UTC](https://www.ruby-forum.com/t/ms-sql-direct-access/75587/1 "2006-11-11T03:16:15Z")

</div>

Just wondering if Ruby can access MS SQL2000 direct - not using ODBC.

John

---

<div class="post-metadata">

**Author:** ![johnf](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/848f3c/32.png) [@johnf](https://www.ruby-forum.com/u/johnf)\
**Post date:** [November 11, 2006, 4:56am UTC](https://www.ruby-forum.com/t/ms-sql-direct-access/75587/2 "2006-11-11T04:56:25Z")

</div>

On Nov 10, 9:14 pm, johnf [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Just wondering if Ruby can access MS SQL2000 direct - not using ODBC.
> 
> John

Using the win32ole module (on Windows), you can access Microsoft SQL  
Server databases via the ADODB object model.

Incomplete example:

cn = WIN32OLE.new(‘ADODB.Connection’)  
cn.Open(…)  
rs = WIN32OLE.new(‘ADODB.Recordset’)  
rs.Open(…)

Mully

---

<div class="post-metadata">

**Author:** ![johnf](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/848f3c/32.png) [@johnf](https://www.ruby-forum.com/u/johnf)\
**Post date:** [November 11, 2006, 6:46am UTC](https://www.ruby-forum.com/t/ms-sql-direct-access/75587/3 "2006-11-11T06:46:37Z")

</div>

You can also use the MsSqlClient (crappy name, we haven’t thought of  
anything better yet) and ActiveRecord:  
[http://rubyforge.org/projects/mssqlclient](http://rubyforge.org/projects/mssqlclient). It’s a C++ extension that  
used [ADO.Net](http://ADO.Net).

-Scott