hi Michael look up here, this one may shed some light on your problem regardin odbc connection to postgresql.
http://archives.postgresql.org/pgsql-jdbc/2003-01/msg00228.php Check the config files, see if tcp/ip is enabled, also check for login from local (unix socket) odbc drivers dont connect with tcp/ip (not in their default setup, but they could be made to use tcp/ip :-)) .. they use local unix sockets to do so, check if local connections via socket are also enabled. On Saturday 01 March 2003 14:55, you wrote: Hope thisone helped a bit. Cheers Szemir > Hi all, > I'm having a bit of trouble getting jdbc to connect to my postgres db. I > can connect to the database fine using psql with a connection string like > ./psql -d iala -p 5432 -U postgres -W -h 127.0.0.1 > > When I try to make that same connection with jdbc, i get the following > error: IDENT authentication failed for user "postgres" > > Any ideas on why this would work with psql, but fail to authenticate when > using jdbc? > > Thanks, > Michael
