DB: Sybase Anywhere10 on WindowsXP
Client: Sybase Anywhere11 on RHEL (Linux) 5.4
ODBC: unixODBC 2.3.1 on Linux
Trying to connect remotely to a Sybase Anywhere 10 database running on WindowXP Professional SP3 from a Red Hat Enterprise Linux 5.4 using a Sybase Anywhere 11 client and unixODBC 2.3.1 (64-bit).
unixODBC isql tool does not connect -- gives following error:
isql -v txeis dba sql
[08001][unixODBC][Sybase][ODBC Driver][SQL Anywhere]Database server not found
[ISQL]ERROR: Could not SQLConnect
I can ping the remote server where the Sybase database resides. I can see that the default port (2638) is open. I can connect to this database using Sybase Central from my PC, which of course is remote.
unixODBC:
----------
odbcinst -j
unixODBC 2.3.1
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /etc/odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
/usr/local/etc/odbcinst.ini
-------------------------
#Driver for Sybase Anywhere 11 with unixODBC
[txeis]
Description = Sybase SQL Anywhere
Driver = /opt/sqlanywhere11/lib64/libdbodbc11.so
Setup = /opt/sqlanywhere11/lib64/libdbodbc11.so
FileUsage = 1
/usr/local/etc/odbc.ini
-------------------------
[ODBC Data Sources]
txeis = Sybase Anywhere11 ODBC
[txeis]
Driver = txeis
Description = Sybase Anywhere Driver DSN txeis
Server = txeis
Port = 2638
User = dba
Password = sql
Database = DB246111
================================
Is anyone aware of any issues with this configuration? I am able to connect with another configuration similar to this -- i.e. it is identical except the Sybase database is local.