SQL Anywhere database connection error using sqlanydb

[Laedrilga]

Hello,

I am experiencing an error when trying to start a Python application that uses the sqlanydb library to connect to an SQL Anywhere database. The error message is:

sqlanydb.InterfaceError: ('Could not load dbcapi. Tried: C:\Program Files\SQL Anywhere 16\bin64,dbcapi.dll,libdbcapi_r.so,libdbcapi_r.dylib', 0)

This error indicates that the sqlanydb library is unable to load the dbcapi library, which is required to connect to SQL Anywhere databases. I have installed SQL Anywhere 16 and have verified that the dbcapi.dll file is located in the C:\Program Files\SQL Anywhere 16\bin64 directory.

I have also added the SQLANY_API_DLL environment variable with the full path to the dbcapi.dll file, but the problem persists.

Could you please advise on how to resolve this error?

Environment:

Operating system: Windows 11
Python: 3.11
sqlanydb: 1.0.13
SQL Anywhere 16

I would appreciate your help in resolving this issue so that I can use the Python application to its full potential.

Thank you for your time and attention to this matter.

Sincerely,
Pietro

[ASk1]

SQLANY_API_DLL=C:\Program Files\SQL Anywhere 16\bin64\dbcapi.dll
or
C:\Program Files\SQL Anywhere 16\bin64 should be in path i think