[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

MS SQL direct access

John Fabiani

11/11/2006 2:14:00 AM

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

John

2 Answers

David Mullet

11/11/2006 3:51:00 AM

0



On Nov 10, 9:14 pm, johnf <jfabi...@yolo.com> 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

Scott

11/11/2006 5:45:00 AM

0

You can also use the MsSqlClient (crappy name, we haven't thought of
anything better yet) and ActiveRecord:
http://rubyforge.org/projects/m.... 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