Page 1 of 1

An invalid tabular data stream (TDS) collation was encountered

Posted: Fri 17 Jun 2016 11:28
by Devil1925
Hello, I'm using uniDAC 6.3.12 with Delphi 10 Seattle. With the following code I'm trying to write into a MSSQL 2012 database.

Code: Select all

  while not Daten.Q_Kunden.Eof do
    begin
      Daten.Q_MSSQL_Export.Locate('Kunden_Nr', Daten.Q_Kunden.FieldByName('Kunden_Nr').AsInteger, []);

      if Daten.Q_MSSQL_Export.FieldByName('Changed_Last').AsDateTime < Daten.Q_Kunden.FieldByName('Changed_Last').AsDateTime then
        begin
          Daten.Q_MSSQL_Export.Edit;
          for i := 0 to Daten.Q_MSSQL_Export.Fields.Count-1 do
            begin
              FieldName := Daten.Q_MSSQL_Export.Fields[i].FullName;
              // Felder durchlaufen
              if (Daten.Q_Kunden.FindField(FieldName) <> nil) then
                begin
                  if Daten.Q_Kunden.FieldByName(FieldName).Value <> Daten.Q_MSSQL_Export.FieldByName(FieldName).Value then
                    Daten.Q_MSSQL_Export.FieldByName(FieldName).Value := Daten.Q_Kunden.FieldByName(FieldName).Value;
                end;
            end;
          Daten.Q_MSSQL_Export.Post;
        end;
      Daten.Q_Kunden.Next;
    end;
When the part

Code: Select all

Daten.Q_MSSQL_Export.Post;
is Executed, I get the exception 'An invalid tabular data stream (TDS) collation was encountered.'.
What am I doing wrong?

I get this exception only on Android!

Re: An invalid tabular data stream (TDS) collation was encountered

Posted: Fri 17 Jun 2016 12:44
by ViktorV
We have already fixed "An invalid tabular data stream (TDS) collation was encountered" error. This fix will be added in the next UniDAC build, that we plan to release next week.