I need to put the item-id of a newly created appointment into a table. The Database is Unify Sqlbase and i use their .net data provider to access it.
My code goes as follow:
ItemId newAppointmentID = user.ExchangeConnection.createAppointment(subtype, text, finalDateVor, finalDateNach);
SQLBaseCommand writeComm = sqlbaseConnection.CreateCommand();
writeComm.CommandText = "UPDATE TAG_CHILD SET OUTL_ID = :outlID WHERE ID_TAGCHILD = " + id_tagchild.ToString();
writeComm.Parameters.Add("outlID", DbType.String).Value = newAppointmentID.UniqueId;
writeComm.ExecuteNonQuery();
writeComm.Dispose();
Unfortunately when i execute this code i get the following error message:
Failed to execute sql statement: UPDATE TAG_CHILD SET OUTL_ID = :1 WHERE ID_TAGCHILD = 1. Please check additional information below. Additional SQLBase message: 10446 SQL UBC Unicode conversion failed. Reason: Failed to convert input( or output) buffer to (or from) Unicode format. Remedy: None.
When I try it with another input instead the item id it works fine.
edit: Here is an example item-id:
AAMkADRjNjdkYmM3LTRmYTgtNGQ1MC1iZGYwLTAxNDgzMzliZDRlNQBGAAAAAACTSYRi78lLQKmfaQQPiPKaBwAzcgSiDDjESLRM1ic9tu8MACLUEMIMAAAzcgSiDDjESLRM1ic9tu8MAN8U8BU+AAA=