ADSODBC and OpenSSL

[reinaldocrespo]

Hello everyone;

Is anyone connecting to an Advantage Database data dictionary using ODBC?

I'm having problems trying to connect using an ODBC DNS entry. I'm using ADSODBC and ADSODBC64 from ADS ver 10.10. Here is the error:

Connection failed: [iAnywhere Solutions][Advantage SQL][ASA] Error 7160: Unable to find or load one of the OpenSSL libraries. axServerConnect

The help file describes 7160 error as:

Problem: Advantage Database Server was not able to load the OpenSSL libraries. In order to use AES encryption or TLS communications, you must have the FIPS Encryption Security Option available.
Solution: If the libraries are available, verify that they are in a path location that the server can access.

Obviously the connect function is not finding the appropriate SSL .dlls but I have no idea which version is it that works or where to place these files.

Can someone help?

Thank you.

[Antonio Linares]

Dear Reinaldo,

Place the OpenSSL DLLs in a location where the system or ADSODBC driver can find them. Here are some common locations to check:
The same directory as the ODBC driver (adsodbc.dll).
A system-wide location like C:\Windows\System32\ for 64-bit or C:\Windows\SysWow64\ for 32-bit.
Alternatively, you can add the directory containing the OpenSSL DLLs to your system's PATH environment variable.

Ensure that you're using a version of OpenSSL that's compatible with Advantage Database Server (ADS) 10.10. The OpenSSL libraries should match the version that ADS expects for encryption (AES, TLS, etc.).
Advantage Database typically uses OpenSSL 1.0.x, so using a newer or incompatible version (like OpenSSL 1.1.x or OpenSSL 3.x) could cause issues.

For ADS 10.10, you need OpenSSL libraries in the 0.9.8 series (similar to what's used in ADS 11.10)

[Giovany Vecchi]

Hi, it's better to use OleDb.
Look at this link which has options to connect to the AdvantageDatabase Server in several ways.

https://www.connectionstrings.com/sybase-advantage/