FreeTDS Development Group

[Igor Korot <ikorot01 AT gmail.com>]

This is the ODBC trace log for the freeTDS ODBC driver trying to
connect to Sybase 16 server.

On Wed, Jun 27, 2018 at 11:44 PM, Frediano Ziglio <freddy77 AT gmail.com> wrote:
> 2018-06-27 18:37 GMT+01:00 Igor Korot <ikorot01 AT gmail.com>:
>> 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.
>
> Sounds a silly question: are unixODBC and Sybase driver using the
> same ABI? Yes, sounds crazy but unixODBC can be compiled with
> slightly different ABIs on 64 bit.
> You could enable ODBC tracing to see the last call producing the fault.
> Maybe program is using wide functions and this is the issue?
>
> Frediano
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> https://lists.ibiblio.org/mailman/listinfo/freetds
[ODBC][15829][1530200010.882705][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/__handles.c][460]
                Exit:[SQL_SUCCESS]
                        Environment = 0x636750
[ODBC][15829][1530200010.882949][/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 = 0x636750
[ODBC][15829][1530200010.883038][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLAllocHandle.c][493]
                Exit:[SQL_SUCCESS]
                        Output Handle = 0x637050
[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]
[ODBC][15829][1530200010.924244][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeHandle.c][284]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x637050
[ODBC][15829][1530200010.924322][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeHandle.c][333]
                Exit:[SQL_SUCCESS]
[ODBC][15829][1530200010.924395][/var/tmp/portage/dev-db/unixODBC-2.3.2-r1/work/unixODBC-2.3.2/DriverManager/SQLFreeHandle.c][219]
                Entry:
                        Handle Type = 1
                        Input Handle = 0x636750