On Sep 18, 7:51 pm, John W Higgins <[email protected]> wrote: > On Fri, Sep 18, 2009 at 5:47 PM, gregh <[email protected]> wrote: > > > setting up an ODBC connection works well. > > > require 'rubygems' > > require 'sequel' > > DB=Sequel.odbc('my_odbc_for_excel') > > > I want to connect without having to set up an ODBC connection thru the > > Start->Control Panel->Admininstrative Tools-> etc... > > OK if you only have one file. > > The Ruby ODBC driver allows you to either create a dsn (add_dsn, delete_dsn, > read_file_dsn) - that should allow you to manipulate either an app DSN or > just create one on the fly. I have no idea how they work but they do exist. > Probably looking at the source to Ruby-ODBC would be a good starting point.
Even if you can make the connection, how does record querying work? Does it use SQL? Jeremy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
