Re: Problem with the latest Sybase ODBC driver

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.

>
> 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://lists.ibiblio.org/mailman/listinfo/freetds