Skip to Content.
Sympa Menu

freetds - [freetds] FreeBSD (unixODBC) to QNX Sybase

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Kamil Parkanyi" <parkanyi AT procaut.sk>
  • To: "freetds" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] FreeBSD (unixODBC) to QNX Sybase
  • Date: Mon, 12 Jun 2006 10:56:07 +0100

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





Archive powered by MHonArc 2.6.24.

Top of Page