From: Ernest Ellingson <erne@...>
Date: 2005-10-25T22:52:03+09:00
Subject: Re: postgres DBI question

Chris Newman wrote:
> 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
> 
Here's a link to some documentation on the dbi.
http://www.kitebird.com/articles/ruby-dbi.html
Hope it helps

Ernie