Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.


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
-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:

content of odbc.ini

[ODBC Data Sources]  
ads = Advantage ODBC Driver

Description=Advantage ODBC driver  
DefaultType=Visual FoxPro  


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.




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/ -> having the ADS Mount point to the DataAdt Folder on the Database Server

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

asked 27 May '16, 07:50

M4R1U5's gravatar image

accept rate: 0%

edited 27 May '16, 09:06

Volker%20Barth's gravatar image

Volker Barth


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.

(27 May '16, 08:01) Volker Barth
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 27 May '16, 07:50

question was seen: 2,589 times

last updated: 27 May '16, 09:06