Postgresql could not connect to

[ngoc]

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('DBIg: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