Getting "Socket error on reading" with SQL Server on Azure
Posted: 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?
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?