[freetds] Can't connect with ODBC

Igor Korot ikorot01 at gmail.com
Sat Feb 6 17:49:25 EST 2021


Hi, ALL,
I have Sybase 16.0 installed on my Gentoo box and just installed freeTDS
(version 1.00.558 from Gentoo repository).

Next I modified odbc configuration as follows:

[code]
IgorReinCloud /etc/portage/package.use # cat /etc/unixODBC/odbcinst.ini
[ODBC]
Trace=yes
TraceFile=/tmp/sql.log

[freeTDS]
Description=FreeTDS Driver
Driver=/usr/lib64/libtdsodbc.so
FileUsage=1
[/code]

[code]
IgorReinCloud /etc/portage/package.use # cat /etc/unixODBC/odbc.ini
[freetds]
Driver=freeTDS
Description=FreeTDS driver
Trace=Yes
Server=IgorReinCloud
Database=draft
Port=5000
TDS_Version=5.0
[/code]

[code]
IgorReinCloud /etc/portage/package.use # hostname
IgorReinCloud
[/code]

[code]
igor at IgorReinCloud ~ $ isql freetds sa wasqra
[ISQL]ERROR: Could not SQLConnect
[/code]

[code]
ODBC][20736][1612650402.974333][/var/tmp/portage/dev-db/unixODBC-2.3.5-r1/work/unixODBC-2.3.5/DriverMa$
                Entry:
                          Connection = 0x55dcbc900b90
                        Server Name = [freetds][length = 7 (SQL_NTS)]
                        User Name = [sa][length = 2 (SQL_NTS)]
                        Authentication = [******][length = 6 (SQL_NTS)]
                UNICODE Using encoding ASCII 'UTF8' and UNICODE 'UTF16LE'

                DIAG [01000] [FreeTDS][SQL Server]Unknown host machine name.

                DIAG [S1000] [FreeTDS][SQL Server]Unable to connect to
data source
[/code]

[code]
igor at IgorReinCloud ~ $ cat /opt/sap/interfaces

REINCLOUD
    master tcp ether localhost 5000
    master tcp ether IgorReinCloud 5000
    query tcp ether localhost 5000
    query tcp ether IgorReinCloud 5000


REINCLOUD_BS
    master tcp ether localhost 5001
    query tcp ether localhost 5001


REINCLOUD_XP
    master tcp ether localhost 5002
    query tcp ether localhost 5002


REINCLOUD_JSAGENT
    master tcp ether localhost 4900
    query tcp ether localhost 4900

[/code]

What am I missing?

Thank you.


More information about the FreeTDS mailing list