Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem with the latest 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] Problem with the latest Sybase ODBC driver
  • Date: Thu, 28 Jun 2018 15:02:04 +0000


> On Jun 28, 2018, at 5:36 AM, Igor Korot <ikorot01 AT gmail.com> wrote:
>
> Hi, John,
>
> On Wed, Jun 27, 2018 at 11:14 AM, John Kendall <john AT capps.com> 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
>> <ikorot01 AT gmail.com<mailto:ikorot01 AT gmail.com>> 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
>> FreeTDS AT lists.ibiblio.org<mailto:FreeTDS AT lists.ibiblio.org>
>> https://url.emailprotection.link/?a95lm_Yz0z4VwVi9HMyQSLtTmToR48n_2Es8x43dIoxidNPkdt4wWeUhbwN1QnbrzawQmZ1BjbOu5bK1zLGmRSw~~
>>
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS AT lists.ibiblio.org
>> https://url.emailprotection.link/?a95lm_Yz0z4VwVi9HMyQSLtTmToR48n_2Es8x43dIoxidNPkdt4wWeUhbwN1QnbrzawQmZ1BjbOu5bK1zLGmRSw~~
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> https://url.emailprotection.link/?a95lm_Yz0z4VwVi9HMyQSLtTmToR48n_2Es8x43dIoxidNPkdt4wWeUhbwN1QnbrzawQmZ1BjbOu5bK1zLGmRSw~~





Archive powered by MHonArc 2.6.24.

Top of Page