FreeTDS Development Group

["Kamil Parkanyi" <parkanyi AT procaut.sk>]

Hello,

I'm trying to connect Sybase SQL Anywhere 5.0.5 using ODBC from FreeBSD.
But it seems it's not so easy.
I did ODBC connection using ODBC to Oracle db.
Cause there is not direct sybase odbc library, all examples on the Net for 
Unix -> Sybase show using FreeTDS in unixODBC.
I would like to know where i'm wrong.

Here is my config:
################################################
freetds.conf :

# server specific section
[global]
        # TDS protocol version
        tds version = 4.2
        initial block size = 512

        swap broken dates = no
        swap broken money = no

        try server login = yes
        try domain login = no

        text size = 64512

[JDBC]
        host = 192.138.151.39
        port = 4444
        tds version = 5.0

[JDBC_42]
        host = 192.138.151.39
        port = 4444
        tds version = 4.2

[mypool]
        host = 127.0.0.1
        port = 5000
        tds version = 4.2

[eneDB]
        host = 10.3.12.202
        port = 1498
;       tds version = 5.0
################################################
odbcinst.ini:

[Oracle]
Description     = Oracle Driver
Driver          = /usr/local/lib/liboraodbc.so
Setup           = /usr/local/lib/liboraodbcS.so
FileUsage       = 1

[FreeTDS]
Description     = FreeTDS Driver
Driver          = /usr/local/lib/libtdsodbc.so
FileUsage       = 1

################################################
odbc.ini

[emSQL]
Description=Sybase
Driver=FreeTDS
Server=10.3.12.202
Servername=eneDB
Database=eneDB.db
TDS_version=4.2

################################################

pvs1_6# isql -v emSQL dba sql
src/tds/login.c: tds_connect: 10.3.12.202:1498: Connection refused
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[08S01][unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[ISQL]ERROR: Could not SQLConnect

I tried to connect with TDS version 5.0 with same result.


Here is list of Sybase server file descriptors from QNX command line.
Server is listening on UDP port 1498

Fri Jun 09 12:55:47 2006
# sin -P dbs fd
PROGRAM                   PID
//1/*/bin/dbsrv50         212
   0 -//1/dev/con3
   1 -//1/dev/con3
   2 -//1/dev/con3
   3 -//1/*/sqlany50/bin/wl50en.res
   4C-//1/dev/con3
   5C-//1 [con]
   6 -//1  U          0.0.0.0.1498           0.0.0.0.0     N/A
   7 -//1/hd/EM/DB/eneDB.db
   8 -//1/tmp/_6K.1.AAB
   9 -//1/d/logfile/eneDB.log
#

Thanks,

Kamil