This is a multi-part message in MIME format.
------_=_NextPart_001_01C8F6A6.805ECAB8
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi all,
I am using Postgres 8=2E1=2E4 version (Windows native) server and
PSQLODBC=2Edll version 7=2E3=2E2=2E0=2E
It seems SetQueryTimeOut is not implemented in Postgres 8=2E1=2E4=2E
Hence my application hangs sometimes if the database server machine goes
down abnormally=2E
While browsing the application log, I noticed that it hangs in
ExecuteSql method or Record set open functions=2E
Any help is appreciated to solve this problem=2E
Thanks in advance=2E
Regards,
Selva
=20
=20
DISCLAIMER:
---------------------------------------------------------------------------=
--------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and=
intended for the named recipient(s) only=2E
It shall not attach any liability on the originator or HCL or its=
affiliates=2E Any views or opinions presented in=20
this email are solely those of the author and may not necessarily reflect=
the opinions of HCL or its affiliates=2E
Any form of reproduction, dissemination, copying, disclosure,
modification,=
distribution and / or publication of=20
this message without the prior written consent of the author of this
e-mail=
is strictly prohibited=2E If you have=20
received this email in error please delete it and notify the sender=
immediately=2E Before opening any mail and=20
attachments please check them for viruses and defect=2E
---------------------------------------------------------------------------=
--------------------------------------------
------_=_NextPart_001_01C8F6A6.805ECAB8
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=
=3D"urn:schemas-microsoft-com:office:office" xmlns:w=
=3D"urn:schemas-microsoft-com:office:word" xmlns=3D"http://www=2Ew3=
=2Eorg/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=
=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@[EMAIL PROTECTED]
"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@[EMAIL PROTECTED]
"MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@[EMAIL PROTECTED]
4 6 4 5 5 5 2 3 4;}
@[EMAIL PROTECTED]
"MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@[EMAIL PROTECTED]
"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
/* Style Definitions */
p=2EMsoNormal, li=2EMsoNormal, div=2EMsoNormal
{margin:0mm;
margin-bottom:=2E0001pt;
font-size:12=2E0pt;
font-family:"Times New Roman";}
a:link, span=2EMsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span=2EMsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span=2EEmailStyle17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@[EMAIL PROTECTED]
Section1
{size:595=2E3pt 841=2E9pt;
margin:99=2E25pt 30=2E0mm 30=2E0mm 30=2E0mm;}
div=2ESection1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026">
<v:textbox inset=3D"5=2E85pt,=2E7pt,5=2E85pt,=2E7pt" />
</o:shapedefaults></xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=3Dwhite lang=3DJA link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<div>
<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New=
Roman"><span
lang=3DEN-US style=3D'font-size:12=2E0pt;color:navy'>Hi=
all,</span></font><span
lang=3DEN-US><o:p></o:p></span></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span lang=
=3DEN-US
style=3D'font-size:10=2E0pt;font-family:Arial;color:navy'>I am using=
Postgres 8=2E1=2E4
version (Windows native) server and PSQLODBC=2Edll version 7=2E3=2E2=2E0=
=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span lang=
=3DEN-US
style=3D'font-size:10=2E0pt;font-family:Arial;color:navy'>It seems=
SetQueryTimeOut is
not implemented in Postgres 8=2E1=2E4=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span lang=
=3DEN-US
style=3D'font-size:10=2E0pt;font-family:Arial;color:navy'>Hence my=
application hangs
sometimes if the database server machine goes down abnormally=
=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span lang=
=3DEN-US
style=3D'font-size:10=2E0pt;font-family:Arial;color:navy'>While browsing=
the application
log, I noticed that it hangs in ExecuteSql method or Record set open=
functions=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span lang=
=3DEN-US
style=3D'font-size:10=2E0pt;font-family:Arial;color:navy'>Any help is=
appreciated to
solve this problem=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span lang=
=3DEN-US
style=3D'font-size:10=2E0pt;font-family:Arial;color:navy'>Thanks in
advance=
=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span lang=
=3DEN-US
style=3D'font-size:10=
=2E0pt;font-family:Arial;color:navy'>Regards,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span lang=
=3DEN-US
style=3D'font-size:10=
=2E0pt;font-family:Arial;color:navy'>Selva<o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span lang=
=3DEN-US
style=3D'font-size:12=2E0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span lang=
=3DEN-US
style=3D'font-size:12=2E0pt'> <o:p></o:p></span></font></p>
</div>
</div>
</body>
</html>
<table><tr><td bgcolor=3D#ffffff><font color=3D#000000>DISCLAIMER:<br>
---------------------------------------------------------------------------=
--------------------------------------------<br>
<br>
The contents of this e-mail and any attachment(s) are confidential and=
intended for the named recipient(s) only=2E<br>
It shall not attach any liability on the originator or HCL or its=
affiliates=2E Any views or opinions presented in <br>
this email are solely those of the author and may not necessarily reflect=
the opinions of HCL or its affiliates=2E<br>
Any form of reproduction, dissemination, copying, disclosure,
modification,=
distribution and / or publication of <br>
this message without the prior written consent of the author of this
e-mail=
is strictly prohibited=2E If you have <br>
received this email in error please delete it and notify the sender=
immediately=2E Before opening any mail and <br>
attachments please check them for viruses and defect=2E<br>
<br>
---------------------------------------------------------------------------=
--------------------------------------------<br>
</font></td></tr></table>
------_=_NextPart_001_01C8F6A6.805ECAB8--
|
