From: Andy Robbo <arobbo61@...>
Date: 2007-06-05T03:04:11+09:00
Subject: Re: Using Ruby to get data from an Access Database


> There are lots of ways to get data to and from an Access database,
> depending on whether the Access database is on the same machine as the
> Ruby script and whether the Ruby script is running on a Windows box or
> not. The simplest case would be the database and Ruby script co-resident
> on a Windows box. Then it can be done either with the OLE interface or
> ODBC -- ODBC is preferable since it's more portable.
> 

The script would be running from the same machine as the database.  I've 
used ADO before with Access Databases so i'd probably stick with what I 
know, bit stuck as to how I'd get the right syntax for Ruby, can't find 
exactly what i'm looking for out there on the web.....

Dim adoCon
Dim rsHouse
Dim strSQL
Set adoCon = Server.CreateObject("ADODB.Connection")
Set rsHouse = Server.CreateObject("ADODB.Recordset")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & 
Server.MapPath("Rent_Management_System_V2.mdb")
strSQL = "Select * From House"
rsHouse.Open strSQl, adoCon

Any idea how this sort of thing would work with Ruby (or where I could 
go to find out)

Many thanks for your help

Andy

-- 
Posted via http://www.ruby-forum.com/.