How do I 'compile' the win32ole module and incorporate it with ruby? I downloaded win32ole-0.4.0.zip, mswin32-ruby-odbc.zip and ruby-odbc-0.94.zip but I need to 'make' them? What software do I need? (I don't particularly want to use cygwin as I want to only use software that runs directly on Windows), that is why I downloaded the complete windows version of Ruby. Dougie "Petr Fischer" <petr.fischer / praguesoft.cz> wrote in message news:1103_1015344166 / news.felk.cvut.cz... > You can use WIN32OLE extension (from RAA) and access MS-SQL (and other databases; yes ODBC too) directly > via. Microsoft ADO. Usage is very simple and powerfull (but only for MS Windows world). > > Example: > > ------------------------------------------- > require 'win32ole' > > conn = WIN32OLE.new('ADODB.Connection') > > conn.Open("Provider=MSDASQL.1;Persist Security Info=False;Data Source=ODBC-IB") // change "connection > string" for your DB > > rset = WIN32OLE.new('ADODB.Recordset') > rset.ActiveConnection = conn > > rset.Open("select * from anytable") > > while not rset.EOF do > s = "" > for i in (0..rset.Fields.Count - 1) do > s += ', ' if i > 0 > s += rset.Fields.Item(i).Value.to_s.strip > end > puts s > rset.MoveNext > end > ------------------------------------------- > > > On Tue, 5 Mar 2002 10:30:12 +0200, "Douglas J van Vliet" <dougie / global.co.za> wrote: > > Is there a module available for accessing MS-SQL? > > > > Whether we like it or not, Microsoft is here to stay. Most of my clients > > use MS products (MS-95/98/NT 4.0/2000) and if I want to keep them, I need to > > use Windows. > > > > Dougie > > > > > > >