This is a multipart message in MIME format.
------=_NextPart_000_0001_01CAA676.65ED6950
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi,
After upgrade from psqlodbc_08_04_0100 to psqlodbc_08_04_0200, I could not
update System.Data.Odbc.OdbcType.VarBinary field anymore.
Programming language is C#.
This is the error message:
{System.InvalidOperationException: The connection has been disabled. --->
System.Data.Odbc.OdbcException: ERROR [08S01] commnication error while
preapreand_describe
--- End of inner exception stack trace ---
at System.Data.Odbc.OdbcConnection.ConnectionIsAlive(Exception
innerException)
at System.Data.Odbc.OdbcConnection.HandleErrorNoThrow(OdbcHandl e
hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle,
RetCode retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBeha vior
behavior, String method, Boolean needReader, Object[] methodArguments,
SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBeha vior
behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
The connection is opened before update.
Thank you.
Pairat
------=_NextPart_000_0001_01CAA676.65ED6950
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:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40"><head><meta =
http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii"><meta name=3DGenerator content=3D"Microsoft Word 14 =
(filtered medium)"><style><!--
/* Font Definitions */
[at] font-face
{font-family:"Cordia New";
panose-1:2 11 3 4 2 2 2 2 2 4;}
[at] font-face
{font-family:"Cordia New";
panose-1:2 11 3 4 2 2 2 2 2 4;}
[at] font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
[at] font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
..MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
[at] page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</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 lang=3DEN-US link=3Dblue =
vlink=3Dpurple><div class=3DWordSection1><p =
class=3DMsoNormal>Hi,<o:p></o:p></p><p =
class=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal>After =
upgrade from psqlodbc_08_04_0100 to psqlodbc_08_04_0200, I could not =
update System.Data.Odbc.<span =
style=3D'color:#2B91AF'>OdbcType</span>.VarBinary field =
anymore.<o:p></o:p></p><p class=3DMsoNormal><o:p> </o:p></p><p =
class=3DMsoNormal>Programming language is C#.<o:p></o:p></p><p =
class=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal>This is the =
error message:<o:p></o:p></p><p =
class=3DMsoNormal><o:p> </o:p></p><p =
class=3DMsoNormal>{System.InvalidOperationException: The connection has =
been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] =
commnication error while preapreand_describe<o:p></o:p></p><p =
class=3DMsoNormal> --- End of inner exception stack trace =
---<o:p></o:p></p><p class=3DMsoNormal> at =
System.Data.Odbc.OdbcConnection.ConnectionIsAlive(Exception =
innerException)<o:p></o:p></p><p class=3DMsoNormal> at =
System.Data.Odbc.OdbcConnection.HandleErrorNoThrow(OdbcHandl e hrHandle, =
RetCode retcode)<o:p></o:p></p><p class=3DMsoNormal> at =
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode =
retcode)<o:p></o:p></p><p class=3DMsoNormal> at =
System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBeha vior =
behavior, String method, Boolean needReader, Object[] methodArguments, =
SQL_API odbcApiMethod)<o:p></o:p></p><p class=3DMsoNormal> =
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBeha vior =
behavior, String method, Boolean needReader)<o:p></o:p></p><p =
class=3DMsoNormal> at =
System.Data.Odbc.OdbcCommand.ExecuteNonQuery()<o:p></o:p></p><p =
class=3DMsoNormal><o:p> </o:p></p><p =
class=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal>The =
connection is opened before update.<o:p></o:p></p><p =
class=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal>Thank =
you.<o:p></o:p></p><p class=3DMsoNormal><o:p> </o:p></p><p =
class=3DMsoNormal>Pairat<span =
style=3D'font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p><p =
class=3DMsoNormal><o:p> </o:p></p></div></body></html>
------=_NextPart_000_0001_01CAA676.65ED6950--
