Getting "Socket error on reading" with SQL Server on Azure

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
SimonRescan
Posts: 1
Joined: Mon 16 Aug 2021 14:12

Getting "Socket error on reading" with SQL Server on Azure

Post by SimonRescan » Mon 16 Aug 2021 14:31

Hi

I'm not sure if this is a bug or if I am doing something wrong or if it's just a feature that is not supported.

When trying to connect to an SQL Server hosted on Azure using DevartSQLServerDirect I get the following error:

TDBXError : Socket error on reading

I found that I don't get this error if using DevartSQLServer (the non-direct one)

This looks to be due to the Connection Policy on the Database been set to Redirect, when I change this to be Default or Proxy it connects fine.

I'm using Delphi 2007 / TSQLConnection and the latest demo version of the DBExpress driver.

Is Redirect connection policy supported or is it planed to be supported in the future?

Post Reply