all fields remain readonly using the ado provider

[davy]

Hi,

i'm testing the zeoslib 7.0 on delphi 2010 using a microsoft sql server 2008.
I used to work on delphi 7 also with a microsoft sql server using the mssql protocol.

I would like to switch to the ado provider,
but it has a strange behavior on delphi 2010.

i create a TZQuery at runtime (not readonly) and i'm using the post procedure to update fields (exactly the same as i did before), but the 7.0 version throws exceptions for every field i try to update.
Every field seems to be read-only.

the error is reased from within
procedure TZAbstractRODataset.SetFieldData(Field: TField; Buffer: Pointer);
line 1420:
if Field.ReadOnly and (Field.FieldKind <> fkLookup)
and not (State in [dsSetKey, dsCalcFields, dsFilter, dsBlockRead, dsInternalCalc, dsOpening]) then
DatabaseErrorFmt(SFieldReadOnly, [Field.DisplayName]);

I do not have this problem when i use the mssql provider (on delphi 2010).


I do have a different problem with the mssql provider. I'm no longer able to upload files.
I got an exception:
General SQL Server error:_Check messages from the SQL Server.
Incorrect syntax near 'äŒ'.
The value 'äŒ' is a part of the file i'm trying to upload.


I hope you can give me some advise.

Thanks in advance
Davy