unable to connect to postgresql datasource

Hello,

I am trying to connect Windows 2003 webserver to another Windows sever hosting a postgresql database. Network connectivity has been confirmed to the IP address:5432. I am able to telnet successfully on that port.

I downloaded the following driver from http://www.postgresql.org/ftp/odbc/versions/msi/

psqlodbc_08_04_0200.zip<http://wwwmaster.postgresql.org/download/mirrors-ftp/odbc/versions/msi/psqlodbc_08_04_0200.zip> 2009-12-26 15:44:31 4.2 MB

I keep getting the error, " Communication closed during authentication". Connection reset by peer.

Below is the contents of mylog file:

3564-0.000]globals.extra_systable_prefixes = 'dd_;'
[3564-0.000]exe name=odbcad32 plaformId=2
[3564-0.000]aszKey='DSN', value='CCMS'
[3564-0.000]copyAttributes: DSN='CCMS',server='',dbase='',user='',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[3564-0.016]getDSNinfo: DSN=CCMS overwrite=0
[3564-0.016]force_abbrev=0 bde=0 cvt_null_date=0
[3564-0.016]globals.extra_systable_prefixes = 'dd_;'
[3564-0.031]calling getDSNdefaults
[3564-0.031]checking libpq library
[3564-0.094]psqlodbc path based libpq loaded module=00BA0000
[3564-0.094]libpq hmodule=00BA0000
[3564-0.094]libpq_exist=1
[3564-0.110]DliNotifyHook LIBPQ.dll Notify=0
[3564-0.110]DliNotifyHook LIBPQ.dll Notify=1
[3564-0.172]psqlodbc path based libpq loaded module=00BA0000
[3564-1.063]EN_add_connection: self = 00932198, conn = 00934048
[3564-1.063] added at 0, conn->henv = 00932198, conns[0]->henv = 00932198
[3564-1.063]CC_connect: entering...
[3564-1.063]sslmode=disable
[3564-1.063]original_CC_connect: entering...
[3564-1.063]Driver Version='08.04.0200,200912260001' linking 1500 static Multithread library
[3564-1.078]original_CC_connect: DSN = 'CCMS', server = '0.0.0.0, port = '5432', database = '0.0.0.0', username = 'xxxxx', password='xxxxx'
[3564-1.078]connecting to the server socket...
[3564-1.094](0)(null) ERRNO=0
[3564-1.094]connection to the server socket succeeded.
[3564-1.094]startup client_encoding=UTF8
[3564-1.094]sizeof startup packet = 102
[3564-1.094]sent the authentication block successfully.
[3564-1.110]gonna do authentication
[3564-1.110]read -1, global_socket_buffersize=4096
[3564-1.110]Lasterror=10035
[3564-1.125]read 13, global_socket_buffersize=4096
[3564-1.125]auth got 'R'
[3564-1.125]areq = 5 salt=b985a1c100
[3564-1.125]in AUTH_REQ_MD5
[3564-1.125]read -1, global_socket_buffersize=4096
[3564-1.125]Lasterror=10035
[3564-1.125]read -1, global_socket_buffersize=4096
[3564-1.125]Lasterror=10054
[3564-1.125](10)Connection reset by peer. ERRNO=10054
[3564-1.141]auth got ' '
[3564-1.141]CC_error_statements: self=00934048
[3564-1.141]CONN ERROR: func=original_CC_connect, desc='', errnum=210, errmsg='Communication closed during authentication'
[3564-1.156]enter CC_get_error
[3564-1.156]enter CC_create_errormsg
[3564-1.156]msg = 'Communication closed during authentication'
[3564-1.156]exit CC_create_errormsg
[3564-1.156]exit CC_get_error
[3564-44.672]enter CC_Destructor, self=00934048
[3564-44.672]in CC_Cleanup, self=00934048
[3564-44.672]after CC_abort
[3564-44.672]SOCK_Destructor
[3564-44.672]after SOCK destructor
[3564-44.672]exit CC_Cleanup
[3564-44.672]after CC_Cleanup
[3564-44.672]after free statement holders
[3564-44.672]exit CC_Destructor
[3564-44.672]in EN_Destructor, self=00932198
[3564-44.672]clearing conns count=128
[3564-44.672]exit EN_Destructor: rv = 1
[3564-81.422]DETACHING PROCESS

Thank you,

Allen Krause
Cognos Administrator
Synchronoss Technologies
cognosadmin(at)synchronoss(dot)com<mailto:cognosadmin(at)synchronoss(dot)com>
[cid:image001(dot)png(at)01CB5E58(dot)86496100]