The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
252
accept rate: 0%

edited 27 May '16, 09:06

Volker%20Barth's gravatar image

Volker Barth
29.3k287438644

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:

×122
×60
×47
×14
×1

question asked: 27 May '16, 07:50

question was seen: 177 times

last updated: 27 May '16, 09:06