MS SQL direct access

ruby-talk
1

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

John

2

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

···

On Nov 10, 9:14 pm, johnf <jfabi...@yolo.com> wrote:

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

John

3

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

-Scott

johnf wrote:

···

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

John