Error when update VarBinary field C# psqlodbc_08_04_0200
am 05.02.2010 09:17:56 von Pairat Paisalyakit
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
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">
http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
(filtered medium)">
vlink=3Dpurple>
class=3DMsoNormal>Hi,
class=3DMsoNormal>
After =
upgrade from psqlodbc_08_04_0100 to psqlodbc_08_04_0200, I could not =
update System.Data.Odbc.
style=3D'color:#2B91AF'>OdbcType.VarBinary field =
anymore.
class=3DMsoNormal>Programming language is C#.
class=3DMsoNormal>
This is the =
error message:
class=3DMsoNormal>
class=3DMsoNormal>{System.InvalidOperationException: The connection has =
been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] =
commnication error while preapreand_describe
class=3DMsoNormal> --- 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)
class=3DMsoNormal> at =
System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
class=3DMsoNormal>
class=3DMsoNormal>
The =
connection is opened before update.
class=3DMsoNormal>
Thank =
you.
class=3DMsoNormal>Pairat
style=3D'font-family:"Tahoma","sans-serif"'>
class=3DMsoNormal>
Re: Error when update VarBinary field C# psqlodbc_08_04_0200
am 05.02.2010 23:23:57 von Hiroshi Inoue
Hi Pairat,
Pairat Paisalyakit wrote:
> Hi,
>
> After upgrade from psqlodbc_08_04_0100 to psqlodbc_08_04_0200, I could
> not update System.Data.Odbc.OdbcType.VarBinary field anymore.
Could you send me directly the Mylog output?
regards,
Hiroshi Inoue
> 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
--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc