Adam,
The PatternLayout("$X{UserID}") should be %X{FileID} and %X{UserID}
However I don't know why the sql client is not liking the SQL it is trying
to build.
What are the arguments, types and sizes for the InsertAuditEntry stored
procedure?
Nicko
> -Original Message-
> From: Adam Pata
Are you sure it's AnsiString?
Anyway, I did notice that any varchar > 4000 wasn't available. I had
columns with 8000 on them and it couldn't log to them. I also had a text
field and it didn't work. But the following does work for me but I use
String as opposed to AnsiString.