remote database connection

Hi every one,

Any help will be appreciated,

I'm running PosygreSQL 6.4 (that come on the Redhat Linux 6.0 CD) and iodbc
2.5.

I developed an application to access the database through iodbc; every thing
was fine regarding the database and its applications.

For some reason, I have system problems and I have to rebuild the system.
So, every thing have been reinstalled, I did the configuration needed to
rerun the database and the application.

Now accessing the database using "psql" is ok, but when I run the
application I got a connection errors. I did check every thing I could
remember or see in the documentation about setup, configuration, and
installation. Every thing is fine as I know, but I still couldn't connect
to the database.

I tried to trace the error and I got these:
Could not connect to server;
Could not connect to remote socket;

Inside the psqlodbc_xxxxxxxxx.log file I fount these:

conn=134761848, SQLDriverConnect(
in)='DSN=PostgreSQL;Database=scanner;Server=161.69.57.45;ReadOnly=0;UID=beid
', fDriverCompletion=1
DSN info:
DSN='PostgreSQL',server='161.69.57.45',port='',dbase='scanner',user='beid',p
asswd=''

readonly='0',protocol='',showoid='',fakeoidindex='',showsystable=''
conn_settings=''
translation_dll='',translation_option=''
conn=134761848,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=scanner;SERVER=161.69.57.45;P
ORT=5432;UID=beid;PWD=;READONLY=0;PROTOCOL=;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;R
OWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
Global Options: Version='06.30.0250', fetch=100,
socket=4096, unknown_sizes=0, max_varchar_size=254,
max_longvarchar_size=4094
disable_optimizer=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
CONN ERROR: func=SQLDriverConnect, desc='Error from
CC_Connect', errnum=1, errmsg='Could not connect to the server'

------------------------------------------------------------
henv=134759008, conn=134761848, status=0, num_stmts=16
sock=134768144, stmts=134776392, lobj_type=-999
---------------- Socket Info -------------------------------
socket=-1, reverse=0, errornumber=4, errormsg='Could not connect
to remote socket.'
buffer_in=134768184, buffer_out=134772288
buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
=======

Any idea why I'm getting this?
What I should need to do to fix it?

I know there is some where file/s I have to modify or do something to it,
please give a hint.

Thank you very mach.

Network Associates Inc.

Bilal Eid