Loading OpenSSL causing error for ODBC driver about openssl.jl HOT 2 CLOSED

Sorry for the slow response here; after doing a bit of research, I think what's going on is:

• mssql odbc driver actually requires openssl 3.X
• OpenSSL.jl loads a 1.1.X version of the library
• When OpenSSL.jl loads 1.1.X, it prevents the auto-loading of a system openssl lib of 3.X version, which then causes teh odbc driver to have problems.

There currently isn't a binary-built 3.X version of openssl, so this is a bit tricky. I'm guessing if you did:

using ODBC
conn = ODBC.Connection(...)
using OpenSSL
conn = ODBC.Connection(...)

then both connections would work? So then the question would be if we can force the system openssl to be loaded, something like:

using ODBC, Libdl
Libdl.dlopen("libssl")
using OpenSSL
ODBC.Connection(...)

from openssl.jl.

Thanks so much for the suggestion! Forcing libssl to be loaded beforehand by using dlopen did the trick. Really appreciate you taking the time to look into it

from openssl.jl.