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.

asked 27 May '16, 07:50

M4R1U5's gravatar image

M4R1U5
2512
accept rate: 0%

edited 27 May '16, 09:06

Volker%20Barth's gravatar image

Volker Barth
30.0k294448654

2

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×124
×61
×46
×14
×1

question asked: 27 May '16, 07:50

question was seen: 233 times

last updated: 27 May '16, 09:06