Skip to Content.
Sympa Menu

freetds - [freetds] Can't connect with ODBC

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Igor Korot <ikorot01 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Can't connect with ODBC
  • Date: Sat, 6 Feb 2021 16:49:25 -0600

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.

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


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.




Archive powered by MHonArc 2.6.24.

Top of Page