MS SQL direct access

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

John

On Nov 10, 9:14 pm, johnf [email protected] 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

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

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs