Re: Problem with the latest Sybase ODBC driver

Maybe you should check the encryption setting for Sybase.
About one year ago, we were were submitting a patch for this.

-- 
Fredy Paquet 
OPAG Informatik AG
Fabrikmattenweg 11
CH-4144 Arlesheim 
Tel. 0041 61 7169222 
Fax. 0041 61 7169229 
http://www.opag.ch 


Am 3. Juli 2018, 07:09, schrieb Frediano Ziglio:
2018-07-01 6:08 GMT+01:00 Igor Korot <[email protected]>:
Frediano,

On Sat, Jun 30, 2018 at 8:08 PM, Igor Korot <[email protected]> wrote:
Frediano,
Any idea why freeTDS fails to connect?


Too many issues in this thread, I'm a bit confused, from Sybase
libraries to crash to ODBC settings, I'll try to reply to this one

I was able to connect with tsql by adding to freetds.conf:

[code]
[MySybase]
host = IGORREINCLOUD
port = 5000
tds version = 5.0
[/code]

and then doing from the command prompt:

[code]
igor@IgorReinCloud ~/dbhandler $ tsql -S MySybase -U dba -P wasqra
locale is "en_US.utf8"
locale charset is "UTF-8"
using default charset "UTF-8"
Msg 4002 (severity 14, state 1) from IGORREINCLOUD:
"Login failed.
"

This is failing, I suspect you are trying a wrong user/password

There was a problem connecting to the server
igor@IgorReinCloud ~/dbhandler $ tsql -S MySybase -U sa -P wasqra
locale is "en_US.utf8"
locale charset is "UTF-8"
using default charset "UTF-8"
Msg 5704 (severity 10, state 1) from IGORREINCLOUD:
"Changed client character set setting to 'iso_1'.
"

This is a successful connection.

1> USE draft;
2> go
Msg 102 (severity 15, state 181) from IGORREINCLOUD Line 1:
"Incorrect syntax near ';'.
"
1> USE draft
2> go
1> SELECT * FROM leagues
2> go
id    name    drafttype    scoringtype    roundvalues    leaguetype
salary    benchplayers
1    Demo - Roto (Auction)    1    1    1    demo     260    0
2    Demo - Roto (Draft)    3    1    1    demo     260    0
3    Demo - Points (Auction)    1    2    1    demo     260    0
4    Demo - Points (Draft)    3    2    1    demo     260    0
(4 rows affected)
1> quit
igor@IgorReinCloud ~/dbhandler $
[/code]

Do you see any issues with my freeTDS ODBC configuration?


Looking back at ODBC I would say the option is "TDS_Version", not "TDS
Version", see http://www.freetds.org/userguide/odbcconnattr.htm.
Usually the steps I take are setting up tsql, then use "Servername" in
odbc.ini then more from freetds.conf to odbc.ini the various settings
to get an odbc only configuration.

At the beginning you were using Sybase drivers, with FreeTDS you can
use TDSDUMP and TDSDUMPCONFIG environment to help debugging, see
http://www.freetds.org/userguide/logging.htm.

Thank you.


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.

Not much experience with Gentoo, looks like directories are completely
different.

Frediano
_______________________________________________
FreeTDS mailing list
[email protected]
https://lists.ibiblio.org/mailman/listinfo/freetds

_______________________________________________
FreeTDS mailing list
[email protected]
https://lists.ibiblio.org/mailman/listinfo/freetds