From: Robert Klemme <shortcutter@...>
Date: 2009-10-27T22:01:14+09:00
Subject: Re: SQL Shell for MS Access

2009/10/27 Paul Smith <paul@pollyandpaul.co.uk>:
> What I want is an SQL command prompt allowing me to run SQL queries
> against an Access .mdb.
>
> I thought that Ruby/DBI included a sqlsh.rb script that essentially
> did this, but no matter how I install Ruby/DBI I can't find the SQL
> shell that I want.
>
> So - does Ruby/DBI even include an SQL shell anymore?  Is there
> another way to get an SQL prompt for MS Access in a similar way to
> what you can do with mysql for example?

I doubt Ruby/DBI ever included what you need.  In order to be able to
directly run SQL against an mdb file you need any DB engine.  Ruby/DBI
is just an interfacing layer and does not include anything like a
complete DB engine.

Having said that, you can use OpenOffice to open mdb files and also
execute queries against it.

Kind regards

robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/