Welcome!

PowerBuilder Authors: Chris Pollach, Yeshim Deniz, Jayaram Krishnaswamy, Kevin Benedict, Avi Rosenthal

Blog Feed Post

Do You Need to Connect to SQL Anywhere 16 from OpenOffice 4.0? - Part 2

In the following post,

http://hodentek.blogspot.com/2013/08/do-you-need-to-connect-to-sql-anywhere.html

An ODBC connection to SQL Anywhere sample database ‘demo’ was established in OpenOffice 4.0.

Using an ODBC connection presented some problem as described in the above post. Specifically the main problem was you could connect to SQL Anywhere 16’s demo database and see the objects in OpenOffice 4.0, but it was not possible to display the data in the tables. It was assumed that probably the driver was wrong. This assumption may not be correct.

In order to sort out this problem the following test was conducted:

As the connectivity did not throw any exceptions and the demo database objects were visible a table Sept11 with DBA Schema was created (in OpenOffice 4.0) as shown. This assumes that a database in OpenOffice 4.0 has been created using the ODBC connection and that the SQL Anywhere 16’s Personal Server Sample (x64) is running.



It was then populated with some simple data as shown and the database aug31.odb was refreshed.


Sept11 was then opened in Sybase Central to see if the changes are updated. The result is shown here.


Double clicking Sept11 table displays the details as shown.



Clicking Data displays the sample data crated in OpenOffice 4.0 as shown.



Looks like this works from OpenOffice 4.0 to SQL Anywhere 16.
However, going back to OpenOffice 4.0 to reopen Sept11 resulted in an error. The main problem appears to be in OpenOffice 4.0.
 

Read the original blog entry...

More Stories By Jayaram Krishnaswamy

Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server Integration Services published by Packt Publishers in the UK. His book, 'Learn SQL Server Reporting Services 2008' was also published by Packt Publishers Inc, Birmingham. 3. "Microsoft SQL Azure Enterprise Application Development" (Dec 2010) was published by Packt Publishing Inc. 4. "Microsoft Visual Studio LightSwitch Business Application Development [Paperback] "(2011) was published by Packt Publishing Inc. 5. "Learning SQL Server Reporting Services 2012 [Paperback]" (June 2013) was Published by Packt Publishing Inc. Visit his blogs at: http://hodentek.blogspot.com http://hodentekHelp.blogspot.com http://hodnetekMSSS.blogspot.com http://hodnetekMobile.blogspot.com He writes articles on several topics to many sites.