Problem with many connections from RHEL 8.10 to SQL Server
0
votes
1
answer
405
views
I have simple script:
for i in {1..1000}
do
isql -v -k "Driver={ODBC Driver 17 for SQL Server};Server=mssqlserver,1282;Database=dbname;UID=user;PWD=xxx;Encrypt=no" >> aaa.log &
done
We upgraded OS from RHEL 7.9 to 8.10.
ODBC drivers installed: 11, 13, 17.
Now, when I execute it 99% of the connections are OK, BUT some of them end in error:
> SQL> [Microsoft][ODBC Driver 13 for SQL Server]TCP Provider: Error code 0x2746
[Microsoft][ODBC Driver 13 for SQL Server]Client unable to establish connection
Such amount of connections are needed in one of SAS programs. 100% of successful connections were in the RHEL 7.9 release.
Can you advice if there is a parameter in Linux, or maybe some ODBC, OPENSSL to have it working again?
I have tried rolling back to RHEL 7.9 and the script is working without any issues.
Asked by Juraj
(11 rep)
Jul 17, 2024, 02:09 PM
Last activity: Aug 20, 2024, 01:28 PM
Last activity: Aug 20, 2024, 01:28 PM