Connecting to ADS Server 11.1 via ODBC Linux

[Former Member]

Hello,

I'm having a lot of Trouble connecting to a Windows ADS Server from Linux via ODBC. Upon calling "isql ads -v" Error i receive is the following :

[S1000][unixODBC][iAnywhere Solutions][Advantage SQL][ASA] Error 6060:  Advantage Database Server not available on specified server.  axServerConnect
[ISQL]ERROR: Could not SQLConnect

For Starters let me try to gather all necessary Informations

-Advantage Database Server 11.10.0.10
-Ubuntu 14.04 LTS x86_64 -PHP 5.5.9
-UnixODBC 2.2.14p2 (if that even matters)
-ADS Directory mounted to "/mnt/ADS" on my System. it points directoy to the final Folder (where the .add's are)
-Advantage ODBC Driver Release 11.1 for Linux (32-bit and 64-bit) Version: 11.10.0.24

content of odbc.ini
{

[ODBC Data Sources]  
ads = Advantage ODBC Driver

[ads]  
Driver=/usr/local/ads/odbc/redistribute/x64/libadsodbc.so  
DataDirectory=/mnt/ADS/ 
Description=Advantage ODBC driver  
Rows=False  
MemoBlockSize=64  
DefaultType=Visual FoxPro  
MaxTableCloseCache=0  
LOCKING=Record  
CharSet=OEM  
ADVANTAGELOCKING=OFF  
ServerTypes=1  
TableExtension=

}

What does work? :

-I am able to Connect to the ADS Server on a Windows Client via the ODBC Driver for Windows
-I am able to Connect to the ADS Server on a Linux Client via the JDBC Driver
-I am able to compile a PHP Version with the Advantage PHP Extension BUT if i try to also compile ODBC Support OR MySSQL (mysqli) support into it, the make process will stop due to an incompatibility in the ADSPHP Extension. This is also the Reason why i need ADS ODBC to work.

What does not? :

-I am unable to Connect to the ADS Server on a Linux Client via the ODBC Driver for Linux.

---

PS : When connecting to ODBC from Windows we usually use the following Connection String.

\\\\192.168.100.96:6262\\ADS\\DataAdt\\database.add

OR

\\\\HOSTNAME\\ADS\\DataAdt\\database.add

i already tried to change the DataDirectory in every plausible way,
-/mnt/ADS/DataAdt/ -> having the ADS Mount point to the ADS Folder on the Database Server
-/mnt/ADS/DataAdt/database.add
-/mnt/ADS/ -> having the ADS Mount point to the DataAdt Folder on the Database Server
-/mnt/ADS/database.add

Please let me know if you need any more Information or if you have an idea. I'd be glad to hear it.

[VolkerBarth]

Note that this forum is for questions on SQL Anywhere, which is a completely different database product.

For questions on Advantage Database Server I'd suggest that SAP forum.