If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Sybase > Sybase Anywhere 10 from Linux

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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 15:55.
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
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)
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On