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: John Kendall <john AT capps.com>
  • To: FreeTDS Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Where is the Sybase ODBC driver
  • Date: Tue, 31 Jan 2017 23:41:25 +0000

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/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
>> https://url.serverdata.net/?ajZrMdQ0VsbeE8kMpqNYWHDt8NhXcTl0gExF9FI8Y1QGyylx0yNkuUl4kfJBSC8Cf02PCfXwjnNlwUAw6zdbO8Q~~
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> https://url.serverdata.net/?ajZrMdQ0VsbeE8kMpqNYWHDt8NhXcTl0gExF9FI8Y1QGyylx0yNkuUl4kfJBSC8Cf02PCfXwjnNlwUAw6zdbO8Q~~
>





Archive powered by MHonArc 2.6.24.

Top of Page