From: David Mullet <david.mullet@...>
Date: 2009-10-27T21:29:25+09:00
Subject: Re: SQL Shell for MS Access

Paul Smith wrote:
> 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?
> 
> Thanks for any insight,
> 
> Paul
> 
> --
> Paul Smith
> http://www.nomadicfun.co.uk
> 
> paul@pollyandpaul.co.uk

I'm not familiar with the mysql shell that you mentioned, but (assuming 
you're on Windows) you could probably tweak the AccessDb wrapper found 
here...

http://rubyonwindows.blogspot.com/2007/06/using-ruby-ado-to-work-with-ms-access.html

...to meet your needs.

David

http://rubyonwindows.blogspot.com
http://rubyonwindows.blogspot.com/search/label/access
-- 
Posted via http://www.ruby-forum.com/.