freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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.
-
[freetds] Can't connect with ODBC,
Igor Korot, 02/06/2021
- Re: [freetds] Can't connect with ODBC, Frediano Ziglio, 02/21/2021
Archive powered by MHonArc 2.6.24.