unable to connect to postgresql datasource

--_004_90F190C982E2034C87EDCFE3740A5EC84D24DCD3pabetszexm01p sn_
Content-Type: multipart/alternative;
boundary="_000_90F190C982E2034C87EDCFE3740A5EC84D24DCD3pabet szexm01psn_"

--_000_90F190C982E2034C87EDCFE3740A5EC84D24DCD3pabetszexm01p sn_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello,

I am trying to connect Windows 2003 webserver to another Windows sever host=
ing 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/v=
ersions/msi/

psqlodbc_08_04_0200.zip p/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". C=
onnection reset by peer.

Below is the contents of mylog file:

3564-0.000]globals.extra_systable_prefixes =3D 'dd_;'
[3564-0.000]exe name=3Dodbcad32 plaformId=3D2
[3564-0.000]aszKey=3D'DSN', value=3D'CCMS'
[3564-0.000]copyAttributes: DSN=3D'CCMS',server=3D'',dbase=3D'',user=3D'',p=
asswd=3D'xxxxx',port=3D'',onlyread=3D'',protocol=3D'',conn_s ettings=3D'',di=
sallow_premature=3D-1)
[3564-0.016]getDSNinfo: DSN=3DCCMS overwrite=3D0
[3564-0.016]force_abbrev=3D0 bde=3D0 cvt_null_date=3D0
[3564-0.016]globals.extra_systable_prefixes =3D 'dd_;'
[3564-0.031]calling getDSNdefaults
[3564-0.031]checking libpq library
[3564-0.094]psqlodbc path based libpq loaded module=3D00BA0000
[3564-0.094]libpq hmodule=3D00BA0000
[3564-0.094]libpq_exist=3D1
[3564-0.110]DliNotifyHook LIBPQ.dll Notify=3D0
[3564-0.110]DliNotifyHook LIBPQ.dll Notify=3D1
[3564-0.172]psqlodbc path based libpq loaded module=3D00BA0000
[3564-1.063]EN_add_connection: self =3D 00932198, conn =3D 00934048
[3564-1.063] added at 0, conn->henv =3D 00932198, conns[0]->henv =3D =
00932198
[3564-1.063]CC_connect: entering...
[3564-1.063]sslmode=3Ddisable
[3564-1.063]original_CC_connect: entering...
[3564-1.063]Driver Version=3D'08.04.0200,200912260001' linking 1500 static =
Multithread library
[3564-1.078]original_CC_connect: DSN =3D 'CCMS', server =3D '0.0.0.0, port =
=3D '5432', database =3D '0.0.0.0', username =3D 'xxxxx', password=3D'xxxxx=
'
[3564-1.078]connecting to the server socket...
[3564-1.094](0)(null) ERRNO=3D0
[3564-1.094]connection to the server socket succeeded.
[3564-1.094]startup client_encoding=3DUTF8
[3564-1.094]sizeof startup packet =3D 102
[3564-1.094]sent the authentication block successfully.
[3564-1.110]gonna do authentication
[3564-1.110]read -1, global_socket_buffersize=3D4096
[3564-1.110]Lasterror=3D10035
[3564-1.125]read 13, global_socket_buffersize=3D4096
[3564-1.125]auth got 'R'
[3564-1.125]areq =3D 5 salt=3Db985a1c100
[3564-1.125]in AUTH_REQ_MD5
[3564-1.125]read -1, global_socket_buffersize=3D4096
[3564-1.125]Lasterror=3D10035
[3564-1.125]read -1, global_socket_buffersize=3D4096
[3564-1.125]Lasterror=3D10054
[3564-1.125](10)Connection reset by peer. ERRNO=3D10054
[3564-1.141]auth got ' '
[3564-1.141]CC_error_statements: self=3D00934048
[3564-1.141]CONN ERROR: func=3Doriginal_CC_connect, desc=3D'', errnum=3D210=
, errmsg=3D'Communication closed during authentication'
[3564-1.156]enter CC_get_error
[3564-1.156]enter CC_create_errormsg
[3564-1.156]msg =3D '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=3D00934048
[3564-44.672]in CC_Cleanup, self=3D00934048
[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=3D00932198
[3564-44.672]clearing conns count=3D128
[3564-44.672]exit EN_Destructor: rv =3D 1
[3564-81.422]DETACHING PROCESS



Thank you,

Allen Krause
Cognos Administrator
Synchronoss Technologies
cognosadmin@synchronoss.com
[cid:image001.png@01CB5E58.86496100]


--_000_90F190C982E2034C87EDCFE3740A5EC84D24DCD3pabetszexm01p sn_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf=3D"http:/=
/schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss=3D"http://sche=
mas.microsoft.com/office/2006/digsig-setup" xmlns:dssi=3D"http://schemas.mi=
crosoft.com/office/2006/digsig" xmlns:mdssi=3D"http://schemas.openxmlformat=
s.org/package/2006/digital-signature" xmlns:mver=3D"http://schemas.openxmlf=
ormats.org/markup-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.c=
om/office/2004/12/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/pa=
ckage/2006/relationships" xmlns:spwp=3D"http://microsoft.com/sharepoint/web=
partpages" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/20=
06/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/200=
6/messages" xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ Sli=
deLibrary/" xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor tal=
Server/PublishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" xmlns:=
st=3D"
" xmlns=3D"http://www.w3.org/TR/REC-html40">


>