Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2011
    Posts
    7

    Angry Sybase Anywhere 10 from Linux

    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.
    Last edited by tale103108; 08-08-12 at 16:55.

  2. #2
    Join Date
    Mar 2012
    Posts
    1
    Quote Originally Posted by tale103108 View Post
    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.
    Your configuration is for local network server (bold line is name for ServerName of your database on local computer) to connect to remote server add this line to your odbc.ini file:
    Code:
    CommLinks=TCPIP(host=ip_your_computer:port_of_SAServer)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •