Postgresql could not connect to


#1

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


#2

ngoc wrote:

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

See these bug tracker items:

http://rubyforge.org/tracker/index.php?func=detail&aid=2344&group_id=234&atid=967
http://rubyforge.org/tracker/index.php?func=detail&aid=3675&group_id=234&atid=967

You may have compiled DBI without Postgres support; or the driver is
missing; or… something else is missing. :slight_smile:

I encountered this problem recently on FreeBSD. I never solved it.

HTH;
Pistos