unixODBC connected but not work

Questions about Wine on Linux
Locked
dersa
Newbie
Newbie
Posts: 1
Joined: Thu Dec 07, 2023 2:08 am

unixODBC connected but not work

Post by dersa »

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
Locked