From: Srikanth Jeeva <sri.jjhero@...>
Date: 2009-10-07T14:15:00+09:00
Subject: Re: new rubier and sql

Hi install dbi driver so that u can access i suppose.


   1. Download the Ruby/DBI distribution from the Ruby/DBI web site, 
unpack and cd into the directory created by unpacking the distribution 
file. For example:

      gunzip dbi-0.1.1.tar.gz
      tar -xvzf dbi-0.1.1.tar
      cd ruby-dbi

   2. Install the Ruby/DBI ODBC driver:

      ruby setup.rb config --with=dbi,dbd_odbc
      ruby setup.rb setup
      ruby setup.rb install

   3. To test the Ruby/DBI ODBC driver with your Easysoft ODBC data 
source, create a Ruby script named ruby-dbi-odbc-example and add these 
lines

      require 'dbi'

      # Replace MY_DSN with the name of your ODBC data
      # source. Replace and dbusername with dbpassword with
      # your database login name and password.
      DBI.connect('dbi:ODBC:MY_DSN', 'dbusername', 'dbpassword') do | 
dbh |
         # Replace mytable with the name of a table in your database.
         dbh.select_all('select * from mytable') do | row |
            p row
         end
      end

   4. Run ruby-dbi-odbc-example:

      ruby ruby-dbi-odbc-example


Here is the source guide.

http://www.easysoft.com/developer/languages/ruby/rails.html


Thanks,
Srikanth J

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