Skip to Content.
Sympa Menu

freetds - Re: [freetds] Where is the Sybase ODBC driver

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: Re: [freetds] Where is the Sybase ODBC driver
  • Date: Tue, 31 Jan 2017 14:49:50 -0800

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/DriverManager/__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/DriverManager/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/DriverManager/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/DriverManager/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/?ajZrMdQ0VsbeE8kMpqNYWHDt8NhXcTl0gExF9FI8Y1QGyylx0yNkuUl4kfJBSC8Cf02PCfXwjnNlwUAw6zdbO8Q~~
>>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page