OpenOffice 4.0 Connecting to SQL Anywhere 16

[mysorian]

It appears I can connect to 'demo' database on SQL Anywhere 16 (SAP) and see the objects in the demo database. However I cannot open the objects (tables). Is there any reason?

An ODBC connection (32 bit) was used in this case.

Interestingly I can create new tables and save them.

Also I could connect to SQL Server 2012 using the ODBC connection. The details for this are here:

http://hodentek.blogspot.com/2013/08/co ... -from.html

The connection steps I took connecting to SQL Anywhere 16 are here:

http://hodentek.blogspot.com/2013/08/do ... where.html

Edited: 9/16/2013

To troubleshoot I reversed the process. Created a table in OpenOffice 4.0 while connected to SQL Anywhere 16 via ODBC and refreshed the data. I could open this table in Sybase Central and view its contents. However, I failed to open the table I created in OpenOffice 4.0 to view contents. Details are here:

http://hodentek.blogspot.com/2013/09/do ... where.html
I am sorry. I have fixed the last link.---10/11/2013

While ODBC connection did not work as expected, I finally tried an ADO connection and this works well. Follow this link here for details:
http://hodentek.blogspot.com/2013/09/do ... re_24.html

[mysorian]

This is not exactly a reply to my original post. But for those who are interested, LibreOffice 4.2 which is similar to OpenOffice 4.0 had no problem in connecting and fetching data from SQL Anywhere 16.

http://hodentek.blogspot.com/2014/02/li ... -than.html

http://hodentekhelp.blogspot.com/2014/0 ... re-16.html