title: ODBC can't find correct OpenSSL version after upgrading OpenSSL
body: <p><strong>Update</strong>: if you have this same issue, the source of the problem is being discussed <a href="https://github.com/microsoft/homebrew-mssql-release/issues/59" rel="noreferrer">here</a></p>
  <hr />
  <p>After upgrading to Python3.10 with homebrew, my OpenSSL was upgraded to version 3 as well.</p>
  <p>Now I can't connect to my SQL Server anymore, since ODBC requires OpenSSL 1.1 or 1.0. So when I run:</p>
  <pre><code>isql -v -k &quot;&lt;connection string&quot;
  </code></pre>
  <p>I get the following error:</p>
  <pre><code>[08001][Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [OpenSSL library could not be loaded, make sure OpenSSL 1.0 or 1.1 is installed]
  [08001][Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection
  </code></pre>
  <p>But when I look in <code>/usr/local/etc/</code> I see that <code>openssl@1.1</code> is installed:</p>
  <p><a href="https://i.stack.imgur.com/I0oIZ.png" rel="noreferrer"><img src="https://i.stack.imgur.com/I0oIZ.png" alt="openssl version" /></a></p>
  <p>How can I solve this problem? Not really familiar with this. So ODBC needs to find the correct OpenSSL version, which is 1.1.</p>
  <p>I tried:</p>
  <pre><code>ln -s /usr/local/Cellar/openssl@1.1/1.1.1g /usr/local/opt/openssl
  </code></pre>
  <p>Also when I run <code>openssl</code> command, it finds the correct version:</p>
  <pre><code>➜  ~ openssl
  OpenSSL&gt; version
  OpenSSL 1.1.1l  24 Aug 2021
  OpenSSL&gt; 
  </code></pre>
  <hr />
  <p>Output <code>brew list openssl@1.1</code></p>
  <pre><code>/usr/local/Cellar/openssl@1.1/1.1.1l_1/.bottle/etc/ (7 files)
  /usr/local/Cellar/openssl@1.1/1.1.1l_1/bin/c_rehash
  /usr/local/Cellar/openssl@1.1/1.1.1l_1/bin/openssl
  /usr/local/Cellar/openssl@1.1/1.1.1l_1/include/openssl/ (104 files)
  /usr/local/Cellar/openssl@1.1/1.1.1l_1/lib/libcrypto.1.1.dylib
  /usr/local/Cellar/openssl@1.1/1.1.1l_1/lib/libssl.1.1.dylib
  /usr/local/Cellar/openssl@1.1/1.1.1l_1/lib/engines-1.1/ (2 files)
  /usr/local/Cellar/openssl@1.1/1.1.1l_1/lib/pkgconfig/ (3 files)
  /usr/local/Cellar/openssl@1.1/1.1.1l_1/lib/ (4 other files)
  /usr/local/Cellar/openssl@1.1/1.1.1l_1/share/doc/ (3971 files)
  /usr/local/Cellar/openssl@1.1/1.1.1l_1/share/man/ (3971 files)
  ➜  ~ 
  </code></pre>
  <p>Output of <code>ls -l /usr/local/opt/openssl/lib/libssl.dylib</code></p>
  <pre><code>lrwxr-xr-x  1 username  admin  14 Sep  7 13:46 /usr/local/opt/openssl/lib/libssl.dylib -&gt; libssl.3.dylib
  </code></pre>
  <p>Also running <code>DYLD_PRINT_LIBRARIES=1 isql -v -k &quot;&lt;connection string&quot;</code> gives me the following. Seems like it is still linked to <code>openssl@3</code></p>
  <pre><code>dyld: loaded:  /usr/local/opt/openssl/lib/libssl.dylib
  dyld: loaded: /usr/local/Cellar/openssl@3/3.0.0/lib/libcrypto.3.dylib
  [08001][Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [OpenSSL library could not be loaded, make sure OpenSSL 1.0 or 1.1 is installed]
  [08001][Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection
  [ISQL]ERROR: Could not SQLDriverConnect
  </code></pre>