From: Robert Klemme <shortcutter@...>
Date: 2009-02-05T21:57:11+09:00
Subject: Re: connecting to an oracle database

2009/2/5 ruud grosmann <r.grosmann@gmail.com>:
> hi group,
>
> I have problems connection to an oracle database using dbi.
>
> machine: debian lenny,
> ruby: ruby 1.8.7 (2008-08-11 patchlevel 72)
>
> Using several descriptions on internet I have downloaded
> ruby-oci8-1.0.3.tar and installed it.
>
> The result is that I can open a database using a OCI8 object, but not
> using a DBI object. I understood that the way to use DBI is by
> installing that package.
>
> Following a test script and its output. Can someone tell me what could
> be wrong? Do I need to install another package?
>
> thanks in advance, Ruud
>
>
> ============ script
> require 'oci8'
> require 'dbi'
>
> connection = OCI8.new( 'user', 'pwd', 'database')
> cursor = connection.exec('select id, description, name from role')
>  while r = cursor.fetch()
>   puts r.join(',')
>  end
>  cursor.close
>  connection.logoff
>
> puts "and now using DBI"
>
> puts DBI.available_drivers
> db = DBI.connect('DBI:OCI8:database', 'user', 'pwd')
> sql = "select id from role"
>
> dbh.select_all(sql) do | row |
>            p row
>        end
>
> dbh.disconnect
>
> ==============output
> 1,admin,admin
> 2,traffic,traffic
> and now using DBI
> dbi:ODBC:
> /usr/lib/ruby/1.8/DBD/ODBC/ODBC.rb:95:in `connect': IM002 (0)
> [iODBC][Driver Manager]Data source name not found and no default
> driver specified. Driver could not be loaded (DBI::DatabaseError)
>        from /usr/lib/ruby/1.8/dbi.rb:424:in `connect'
>        from /usr/lib/ruby/1.8/dbi.rb:215:in `connect'
>        from leesdb:18#

Note, I am not using DBI just trying to throw in my 0.02EUR Oracle knowledge.

Looks like it attempts to not use OCI but ODBC instead. Did you check
output of these:

DBI.available_drivers
DBI.data_sources( driver )

You could also try DBI.trace to get more interesting output.

Btw, you do have an Oracle client installed, do you?

Kind regards

robert

-- 
remember.guy do |as, often| as.you_can - without end