Hi,

is your server configured to serve tcp/ip requests (-i option) ? If not, try leaving away the "host=local" phrase, the driver will then use unix domain sockets.
OK, I commented out the tcp/ip option in hba.conf, left away all that
follows the "sdbc:postgres:" string but the result is always the same.
no, I meant it the other way round.

In OOo, on the General tab of the Data source administration dialog, try the simplest way of connecting to postgresql by simply using

sdbc:postgresql:

(this part is even readonly, you should not be able to modify it).

For this connection attempt, you must see an reaction in the server log. (something like 'database ennio does not exist'). If this is not the case, then there is a more fundamental problem. Which version of postgresql-server are you using ? What does a

netstat -a  | grep PGSQL

give you (it should show something like

unix  2      [ ACC ]     STREAM     LISTENING     14446  /tmp/.s.PGSQL.5432

).

To connect to the mydb database, a

sdbc:postgresql:dbname=mydb

should work.

Bye,

Joerg



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to