0x2746 Error msodbcsql connection to SQL Server 2016
After much research, trial and error. I found resolution in my problem with upgrading openssl (1.1.1f) to a later version I used (1.1.1k).
Following the instructions on this post: How to fix Microsoft ODBC Driver 17 for SQL Server
Even though this was for a different error. Upgrading openssl fixed my TCP Provider 0x2746 error.