Обсуждение: Error when update VarBinary field C# psqlodbc_08_04_0200
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(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
The connection is opened before update.
Thank you.
Pairat
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(OdbcHandle > hrHandle, RetCode retcode) > > at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, > RetCode retcode) > > at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior > behavior, String method, Boolean needReader, Object[] methodArguments, > SQL_API odbcApiMethod) > > at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior > behavior, String method, Boolean needReader) > > at System.Data.Odbc.OdbcCommand.ExecuteNonQuery() > > The connection is opened before update. > > Thank you. > > Pairat