An invalid tabular data stream (TDS) collation was encountered

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Devil1925
Posts: 1
Joined: Fri 17 Jun 2016 11:08

An invalid tabular data stream (TDS) collation was encountered

Post by Devil1925 » Fri 17 Jun 2016 11:28

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!

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

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

Post by ViktorV » Fri 17 Jun 2016 12:44

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.

Post Reply