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          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@synchronoss.com