Re: Problem with the latest Sybase ODBC driver

Frediano,
Any idea why freeTDS fails to connect?

Thank you.


On Thu, Jun 28, 2018 at 8:02 AM, John Kendall <[email protected]> wrote:
>
>> On Jun 28, 2018, at 5:36 AM, Igor Korot <[email protected]> wrote:
>>
>> Hi, John,
>>
>> On Wed, Jun 27, 2018 at 11:14 AM, John Kendall <[email protected]> wrote:
>>> Igor,
>>> I'm on Centos 7.5 and it looks like I'm using the exact same version of ASE:
>>> Adaptive Server Enterprise/16.0 SP02 PL02/EBF 25320 SMP/P/x86_64/Enterprise Linux/ase160sp02plx/2492/64-bit/FBO/Sat Nov 21 04:05:39 2015
>>>
>>> I'm using unixODBC 2.3.1 and the freeTDS odbc driver without issue.
>>> I recall having the Sybase ODBC driver working, but settled on the FreeTDS driver for simplicity.
>>
>> This is my setup:
>>
>> [code]
>> igor@IgorReinCloud ~/dbhandler $ 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
>>
>> [Sybase_freeTDS]
>> Description=Sybase FreeTDS Driver
>> Driver=/usr/lib64/libtdsodbc.so
>> UsageCount=1
>> igor@IgorReinCloud ~/dbhandler $ cat /etc/unixODBC/odbc.ini
>> [ODBC Data Sources]
>> Sybase_16_demo=Sybase 16 ODBC driver
>> Sybase_16_test=Sybase 16 ODBC driver
>> Sybase_16_freeTDS=Sybase_freeTDS
>>
>> [Sybase_16_demo]
>> Description=Sybase 16 ODBC Driver
>> Driver=Sybase
>> Port=5000
>> Server=IGORREINCLOUD
>> UserID=sa
>> Password=
>> Database=pubs2
>> Option=3
>>
>> [Sybase_16_test]
>> Description=Sybase 16 ODBC native driver
>> Driver=Sybase
>> Port=5000
>> Server=IG
>> Server=IGORREINCLOUD
>> UserID=sa
>> Password=
>> Database=draft
>> Option=3
>>
>> [Sybase_16_freeTDS]
>> Description=Sybase 16 freeTDS ODBC driver
>> Driver=Sybase_freeTDS
>> Port=5000
>> Server=IGORREINCLOUD
>> UserID=sa
>> Password=
>> Database=draft
>> TDS Version=5.0
>> Option=3
>> [/code]
>>
>> And this is from the ODBC log for freeTDS driver:
>>
>> [code]
>> [ODBC][15829][1530200010.883129][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLConnect.c][3727]
>>        Entry:
>>            Connection = 0x637050
>>            Server Name = [Sybase_16_freeTDS][length = 17 (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]Adaptive Server connection failed
>>
>>        DIAG [S1000] [FreeTDS][SQL Server]Unable to connect to data source
>>
>> [ODBC][15829][1530200010.924065][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLConnect.c][4099]
>>        Exit:[SQL_ERROR]
>> [/code]
>>
>> The native driver works OK - I can connect without any issues.
>>
>> Do you see any problems?
>>
>> I'm trying to connect with:
>>
>> isql Sybase_16_freeTDS sa <password>
>>
>> Thank you.
>
> Upon further investigation, my ODBC success is via PHP. I  am having problems with unixODBC isql as well.
> So I'm no help.
>
>>
>>>
>>> John
>>>
>>>
>>> On Jun 27, 2018, at 10:37 AM, Igor Korot <[email protected]<mailto:[email protected]>> wrote:
>>>
>>> Hi, ALL,
>>> This post is not directly related to the freeTDS, but I'm hoping that
>>> someone can help.
>>>
>>> I have a latest Sybase 16.0 version Development Edition installed on Linux.
>>> I also have a unixODBC installed.
>>>
>>> I'm trying to connect to the server using the default Sybase ODBC
>>> driver with the
>>> unixODBC isql program.
>>>
>>> Unfortunately I have a problem. The connection works, but then issuing
>>> the simple
>>> query, like "SELECT * FROM <my_table>;", where my table is locatedinside
>>> my local database (the one I created) segfaults.
>>> Trying to do the same with the Sybase demo database works fine.
>>>
>>> I didn't try to do anything with the freeTDS driver yet. I will probably do that
>>> over the weekend.
>>>
>>> Does anybody here have Sybase 16 installed? Did you try ODBC connection
>>> to the server?
>>>
>>> Thank you.
>>>
>>> P.S.: Software versions:
>>> 1> select @@version
>>> 2> go
>>>
>>> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>> Adaptive Server Enterprise/16.0 SP02 PL02/EBF 25320 SMP/P/x86_64/Enterprise Lin
>>> ux/ase160sp02plx/2492/64-bit/FBO/Sat Nov 21 04:05:39 2015
>>>
>>> (1 row affected)
>>> 1> exit
>>>
>>> [/code]
>>>
>>> [code]
>>>
>>> [ebuild U ] dev-db/unixODBC-2.3.5-r1::gentoo [2.3.2-r1::gentoo]
>>> USE="minimal unicode -odbcmanual -static-libs" ABI_X86="32 (64)
>>> (-x32)" 1,596 KiB
>>>
>>> [/code]
>>>
>>> The current version of unixODBC is 2.3.2-r1 from gentoo repository.
>>> _______________________________________________
>>> FreeTDS mailing list
>>> [email protected]<mailto:[email protected]>
>>> https://url.emailprotection.link/?a95lm_Yz0z4VwVi9HMyQSLtTmToR48n_2Es8x43dIoxidNPkdt4wWeUhbwN1QnbrzawQmZ1BjbOu5bK1zLGmRSw~~
>>>
>>> _______________________________________________
>>> FreeTDS mailing list
>>> [email protected]
>>> https://url.emailprotection.link/?a95lm_Yz0z4VwVi9HMyQSLtTmToR48n_2Es8x43dIoxidNPkdt4wWeUhbwN1QnbrzawQmZ1BjbOu5bK1zLGmRSw~~
>> _______________________________________________
>> FreeTDS mailing list
>> [email protected]
>> https://url.emailprotection.link/?a95lm_Yz0z4VwVi9HMyQSLtTmToR48n_2Es8x43dIoxidNPkdt4wWeUhbwN1QnbrzawQmZ1BjbOu5bK1zLGmRSw~~
>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> https://lists.ibiblio.org/mailman/listinfo/freetds