From: Chris Newman <Chris.Newman@...>
Date: 2005-10-25T21:21:47+09:00
Subject: postgres DBI question

------_=_NextPart_001_01C5D95E.A5993884
Content-Type: text/plain

Hi,

I'm trying to connect to a Postgresql database using the DBI and postgres
packages. My OS is Solaris 2.8.

Here's my code snippet...

#!/usr/local/bin/ruby

require 'dbi'
require 'postgres'

dbh = DBI.connect('dbi:Pg:dbname=somedbasename;host=/var/tmp', 'someuser',
'somepasswd')

dbh.disconnect

However, when I run it I get...

/usr/local/lib/ruby/site_ruby/1.8/dbi/dbi.rb:490:in `load_driver':  is not a
class/module (TypeError)
        from /usr/local/lib/ruby/site_ruby/1.8/dbi/dbi.rb:392:in
`_get_full_driver'
        from /usr/local/lib/ruby/site_ruby/1.8/dbi/dbi.rb:372:in `connect'
        from ./ptexec_query.rb:9


I want to use DBI in case I want to change databases in the future. Any
suggestions would be appreciated.

Thanks,

cn

------_=_NextPart_001_01C5D95E.A5993884--