ETDSError Delphi Seattle, SDAC 7.3.12; Direct from Android to MSSQL Server

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
baumwollschaf
Posts: 2
Joined: Sat 03 Mar 2018 08:11

ETDSError Delphi Seattle, SDAC 7.3.12; Direct from Android to MSSQL Server

Post by baumwollschaf » Sat 03 Mar 2018 08:34

Hi there,

I get the following error when I'm trying to connect directly from an app to a MS SQL Server (Provider prDirect):
'An invalid tabular data stream (TDS) collation was encountered.'

My system:
Delphi Seattle, SDAC 7.3.12 (Pro); Direct from Android to MSSQL Server

The MS SQL database ist located at GearHost.

Does anybody have any idea what can I do?

Thanks in advance.

Kind Regards
baumwollschaf

baumwollschaf
Posts: 2
Joined: Sat 03 Mar 2018 08:11

Re: ETDSError Delphi Seattle, SDAC 7.3.12; Direct from Android to MSSQL Server

Post by baumwollschaf » Sat 03 Mar 2018 11:10

Tricky error but solved.

You can't do something like

Code: Select all

Table1BeforeOpen(Sender: TObject);
begin
  Table2.Open;
end;
if you do

Code: Select all

  Table1.Open;
  Table2.Open;
the everything will be fine.

Stellar
Devart Team
Posts: 84
Joined: Tue 03 Oct 2017 11:00

Re: ETDSError Delphi Seattle, SDAC 7.3.12; Direct from Android to MSSQL Server

Post by Stellar » Tue 06 Mar 2018 10:00

Please check if there is an issue with the latest SDAC version 8.0.4 when connecting to MS SQL Server with Android apps and inform us about the result.

Post Reply