Sample Header Ad - 728x90

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