FreeTDS Development Group

[matthew.green AT datamartcomputing.com]

You've probably done this already but just in case.... have you checked using 
 Sybases isql that you can connect? Have you double checked that the server 
really is listening on the right port? To be absolutely certain you could 
look in syslisteners.

Sorry to go back to basics but sometimes these things get overlooked.

Cheers,

Matthew.

February 1 2017 12:41 AM, "John Kendall" <john AT capps.com> wrote:
> Igor,
> 
> In you odbc.ini file you need:
> 
> UserID=root
> 
> not
> 
> User=root
> 
> (You could also put your username and password on the command line.)
> 
> /usr/bin/isql -v "Sybase 16 test" root wasqra
> 
> Other than that, all I can think of is make sure you source the SYBASE 
> environment and use isql's
> -v option to get more information.
> 
> source /opt/sap/SYBASE.sh
> /usr/bin/isql -v "Sybase 16 test" root wasqra
> 
> That's all I know. Really!
> 
> John
> 
> On Jan 31, 2017, at 2:49 PM, Igor Korot <ikorot01 AT gmail.com> wrote:
> 
>> Hi, John,
>> 
>> On Thu, Jan 26, 2017 at 9:42 PM, John Kendall <john AT capps.com> wrote:
>>> Igor,
>>> 
>>> I think it's
>>> 
>>> ./sap/DataAccess64/ODBC/lib/libsybdrvodb.so
>> 
>> I put this in and tried to connect. Here are my configuration files:
>> 
>> igor@IgorReinCloud ~/wxWidgets/buildGTK $ cat /etc/unixODBC/odbcinst.ini
>> [ODBC]
>> Trace=yes
>> TraceFile=/tmp/sql.log
>> Pooling=No
>> 
>> [Sybase]
>> Description=Sybase 16 Native Driver
>> Driver=/opt/sap/DataAccess64/ODBC/lib/libsybdrvodb.so
>> UsageCount=1
>> 
>> igor@IgorReinCloud ~/wxWidgets/buildGTK $ cat /etc/unixODBC/odbc.ini
>> [ODBC Data Sources]
>> Sybase 16 test=Sybase 16 ODBC driver
>> 
>> [Sybase 16 test]
>> Description=Sybase 16 Driver Testing DSN
>> Driver=Sybase
>> Port=5000
>> Server=localhost
>> User=root
>> Password=wasqra
>> Database=draft
>> Option=3
>> 
>> Trying to connect I got:
>> 
>> igor@IgorReinCloud ~/wxWidgets/buildGTK $ /usr/bin/isql "Sybase 16 test"
>> [ISQL]ERROR: Could not SQLConnect
>> 
>> Checking the log file I see:
>> 
>> [quote]
>> 
> [ODBC][16867][1485764524.804129][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/Drive
>> Manager/__handles.c][460]
>> Exit:[SQL_SUCCESS]
>> Environment = 0x2253750
>> 
> [ODBC][16867][1485764524.804240][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/Drive
>> Manager/SQLAllocHandle.c][375]
>> Entry:
>> Handle Type = 2
>> Input Handle = 0x2253750
>> 
> [ODBC][16867][1485764524.804288][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/Drive
>> Manager/SQLAllocHandle.c][493]
>> Exit:[SQL_SUCCESS]
>> Output Handle = 0x2254050
>> 
> [ODBC][16867][1485764524.804334][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/Drive
>> Manager/SQLConnect.c][3727]
>> Entry:
>> Connection = 0x2254050
>> Server Name = [Sybase 16 test][length = 14 (SQL_NTS)]
>> User Name = [NULL]
>> Authentication = [NULL]
>> UNICODE Using encoding ASCII 'UTF8' and UNICODE 'UTF16LE'
>> 
>> DIAG [HY000] [SAP][ASE ODBC Driver]There is no server
>> listening at localhost:5000.
>> 
>> DIAG [08001] [SAP][ASE ODBC Driver]Client unable to establish
>> a connection
>> ]/quote]
>> 
>> But it is here and listening:
>> 
>> [code]
>> IgorReinCloud / # netstat -nptl
>> Active Internet connections (only servers)
>> Proto Recv-Q Send-Q Local Address Foreign Address
>> State PID/Program name
>> tcp 0 0 127.0.0.1:4900 0.0.0.0:*
>> LISTEN 6014/jsagent
>> tcp 0 0 127.0.0.1:5000 0.0.0.0:*
>> LISTEN 5979/dataserver
>> tcp 0 0 0.0.0.0:139 0.0.0.0:*
>> LISTEN 3491/smbd
>> tcp 0 0 0.0.0.0:445 0.0.0.0:*
>> LISTEN 3491/smbd
>> tcp6 0 0 :::139 :::*
>> LISTEN 3491/smbd
>> tcp6 0 0 :::445 :::*
>> LISTEN 3491/smbd
>> [/code]
>> 
>> So what I did wrong?
>> 
>> Thank you.
>> 
>>> But for it to work, you'll need to set up the Sybase environment by 
>>> sourcing ./sap/SYBASE.sh:
>>> 
>>> . ./sap/SYBASE.sh
>>> 
>>> Hope this helps, because I'm out of ideas.
>>> John
>>> 
>>>> On Jan 26, 2017, at 8:56 PM, Igor Korot <ikorot01 AT gmail.com> wrote:
>>>> 
>>>> Hi,
>>>> I just installed Sybase ASE 16 Dev on my Linux box.
>>>> Now I'm trying to set up a connection using native Sybase ODBC
>>>> driver. However I have a hard time finding it.
>>>> 
>>>> [code]
>>>> igor@IgorReinCloud /opt $ find . -name *odbc*
>>>> ./sap/DataAccess/bin/odbcversion
>>>> ./sap/DataAccess/ODBC/samples/odbcbatch
>>>> ./sap/DataAccess/ODBC/samples/odbcbatch/odbcbatch.cpp
>>>> ./sap/DataAccess/ODBC/samples/odbcloblocator
>>>> ./sap/DataAccess/ODBC/samples/odbcloblocator/odbcloblocator.cpp
>>>> ./sap/DataAccess/ODBC/sp/odbc_mda_120.sql
>>>> ./sap/DataAccess/ODBC/sp/odbc_mda_157.sql
>>>> ./sap/DataAccess/ODBC/sp/odbc_mda_1251.sql
>>>> ./sap/DataAccess/ODBC/sp/odbc_mda_1600000.sql
>>>> ./sap/DataAccess/ODBC/sp/install_odbc_sprocs
>>>> ./sap/DataAccess/ODBC/sp/odbc_mda_1570020.sql
>>>> ./sap/DataAccess/ODBC/sp/odbc_mda_125.sql
>>>> ./sap/DataAccess/ODBC/sp/odbc_mda_12503.sql
>>>> ./sap/DataAccess/ODBC/sp/odbc_mda_150.sql
>>>> ./sap/DataAccess/ODBC/sp/odbc_mda_1502.sql
>>>> ./sap/DBISQL-16_0/lib/jodbc4.jar
>>>> ./sap/DBISQL-16_0/bin/libdbodbc16_r.so.1
>>>> ./sap/DBISQL-16_0/bin/libdbodbc16_r.so
>>>> ./sap/DBISQL-16_0/bin/libdbjodbc16.so.1
>>>> ./sap/DBISQL-16_0/bin/libdbjodbc16.so
>>>> ./sap/ASE-16_0/lib/pca/libPCAodbc.so
>>>> ./sap/ASE-16_0/symlib/pca/libPCAodbc.so
>>>> ./sap/COCKPIT-4/bin/sa16/linux64/java/jodbc4.jar
>>>> ./sap/COCKPIT-4/bin/sa16/linux64/lib64/libdbodbc16_r.so
>>>> ./sap/COCKPIT-4/bin/sa16/linux64/lib64/libdbodbc16.so
>>>> ./sap/COCKPIT-4/bin/sa16/linux64/lib64/libdbjodbc16.so
>>>> ./sap/log/odbc.log
>>>> ./sap/log/odbc.lst
>>>> ./sap/DataAccess64/bin/odbcversion
>>>> ./sap/DataAccess64/ODBC/dm/include/unixodbc.h
>>>> ./sap/DataAccess64/ODBC/dm/include/odbc.h
>>>> ./sap/DataAccess64/ODBC/dm/include/saodbc.h
>>>> ./sap/DataAccess64/ODBC/dm/lib64/libodbc.so
>>>> ./sap/DataAccess64/ODBC/samples/odbcbatch
>>>> ./sap/DataAccess64/ODBC/samples/odbcbatch/odbcbatch.cpp
>>>> ./sap/DataAccess64/ODBC/samples/odbcloblocator
>>>> ./sap/DataAccess64/ODBC/samples/odbcloblocator/odbcloblocator.cpp
>>>> ./sap/DataAccess64/ODBC/sp/odbc_mda_120.sql
>>>> ./sap/DataAccess64/ODBC/sp/odbc_mda_157.sql
>>>> ./sap/DataAccess64/ODBC/sp/odbc_mda_1251.sql
>>>> ./sap/DataAccess64/ODBC/sp/odbc_mda_1600000.sql
>>>> ./sap/DataAccess64/ODBC/sp/install_odbc_sprocs
>>>> ./sap/DataAccess64/ODBC/sp/odbc_mda_1570020.sql
>>>> ./sap/DataAccess64/ODBC/sp/odbc_mda_125.sql
>>>> ./sap/DataAccess64/ODBC/sp/odbc_mda_12503.sql
>>>> ./sap/DataAccess64/ODBC/sp/odbc_mda_150.sql
>>>> ./sap/DataAccess64/ODBC/sp/odbc_mda_1502.sql
>>>> [/code]
>>>> 
>>>> Can anyone tell me which one is the Sybase ODBC driver?
>>>> 
>>>> Thank you.
>>>> _______________________________________________
>>>> FreeTDS mailing list
>>>> FreeTDS AT lists.ibiblio.org
>>>> 
>>> 
>> 
> https://url.serverdata.net/?ajZrMdQ0VsbeE8kMpqNYWHDt8NhXcTl0gExF9FI8Y1QGyylx0yNkuUl4kfJBSC8Cf02PCfXw
>>>> nNlwUAw6zdbO8Q~~
>>> 
>>> _______________________________________________
>>> FreeTDS mailing list
>>> FreeTDS AT lists.ibiblio.org
>>> 
>> 
> https://url.serverdata.net/?ajZrMdQ0VsbeE8kMpqNYWHDt8NhXcTl0gExF9FI8Y1QGyylx0yNkuUl4kfJBSC8Cf02PCfXw
>>> nNlwUAw6zdbO8Q~~
>> 
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS AT lists.ibiblio.org
>> 
> https://url.serverdata.net/?ajZrMdQ0VsbeE8kMpqNYWHDt8NhXcTl0gExF9FI8Y1QGyylx0yNkuUl4kfJBSC8Cf02PCfXw
>> nNlwUAw6zdbO8Q~~
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds