[freetds] Can't connect with ODBC

Frediano Ziglio freddy77 at gmail.com
Sun Feb 21 03:41:33 EST 2021


Il giorno sab 6 feb 2021 alle ore 22:46 Igor Korot
<ikorot01 at gmail.com> ha scritto:
>
> 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.
>

This specific error should indicate that FreeTDS is not able to
resolve the address, in this case should be "IgorReinCloud".
Can you try something like "ping IgorReinCloud" ?

>                 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
>

Is the server listening to both addresses (localhost and machine address)?

>
> 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.

Frediano


More information about the FreeTDS mailing list