# Postgresql could not connect to

**URL:** <https://www.ruby-forum.com/t/postgresql-could-not-connect-to/77266>\
**Category:** Ruby\
**Created:** [March 6, 2006, 3:40pm UTC](https://www.ruby-forum.com/t/postgresql-could-not-connect-to/77266 "2006-03-06T15:40:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ngoc](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/e495f1/32.png) [@ngoc](https://www.ruby-forum.com/u/ngoc)\
**Post date:** [March 6, 2006, 3:40pm UTC](https://www.ruby-forum.com/t/postgresql-could-not-connect-to/77266/1 "2006-03-06T15:40:18Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ngoc](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/e495f1/32.png) [@ngoc](https://www.ruby-forum.com/u/ngoc)\
**Post date:** [March 7, 2006, 7:17pm UTC](https://www.ruby-forum.com/t/postgresql-could-not-connect-to/77266/2 "2006-03-07T19:17:13Z")

</div>

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=2344&group_id=234&atid=967)  
[http://rubyforge.org/tracker/index.php?func=detail&aid=3675&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. 🙂

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

HTH;  
Pistos