Skip to Content.
Sympa Menu

freetds - Re: [freetds] Can't connect with ODBC

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Can't connect with ODBC
  • Date: Sun, 21 Feb 2021 08:41:33 +0000

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




Archive powered by MHonArc 2.6.24.

Top of Page