From: ngoc <ngoc@...>
Date: 2006-03-06T23:38:41+09:00
Subject: Postgresql could not connect to

Hi

My environment is Windows XP and have installed 'gem install postgres-pr'.

Postgresql is running.

I have this code for test of connection

require 'dbi'
dbh = DBI.connect('DBI:Pg:my_db:localhost', 'my_account_name', 'my_passwd')
rows = dbh.execute('select * from customer')
row = rows.fetch
puts row[0]

The error message is

C:\>ruby db.rb
c:/program files/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:499:in 
`load_driver':  is not a class/module (TypeError)
         from c:/program 
files/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:401:in `_ge
t_full_driver'
         from c:/program 
files/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:381:in `connect'
         from db.rb:2
Thanks
ngoc