Hello
I have SQLanywhere db running on my Ubuntu. I have installed unixODBC and setled ODBC connection. It works from Python and from linux isql. But when I try to connect from Wine to my DSN ASA, I am getting error
Could not connect to the database.
Can't open lib 'libtdsodbc.so' : file not found
[unixODBC][Driver Manager]Can't open lib 'libtdsodbc.so' : file not found
SQLCODE=0
SQLSTATE=01000
Connection parameters:
User=dba
Password=***
DSN=ASA
Wine see my unixODBC configuration. I have setled 2 dsn in odbc.ini and wine try to use correct dsn (depending what I am calling: ASA or ASA2)
. There is odbc.ini
[ASA]
Driver=FreeTDS
SERVER=198.128.1.2
PORT=2638
DATABASE=mt5
UID=dba
PWD=sql
TDS_Version=8.0
[ASA2]
Driver=FrTDS
SERVER=198.128.1.2
PORT=2638
DATABASE=mt5
UID=dba
PWD=sql
There is my odbcinst.ini
[FreeTDS]
Description=TDS driver (Sybase/MS SQL)
Driver=libtdsodbc.so
Setup=libtdsS.so
[FrTDS]
Description=TDS driver (Sybase/MS SQL)
Driver=/home/user/anaconda3/lib/libtdsodbc.so
Setup=/home/user/anaconda3/lib/libtdsS.so
If I am calling ASA, I am getting
Can't open lib 'libtdsodbc.so' : file not found
If I am calling ASA2, I am getting
Can't open lib /home/user/anaconda3/lib/libtdsodbc.so' : file not found
Is there any way to solve this or I will need to use virtualbox win and normal odbc management instead of wine?
Thank you for your help