Welcome!

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

Related Topics: PowerBuilder

PowerBuilder: Blog Feed Post

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

OpenOffice can access many different kinds of data

Sybase Central 16 is a very nice interface and I never encountered any problem from its earliest version (I jumped in at version 9, may be). However, if you want to connect to a database and create tables; run queries; create views; create forms and reports you can use OpenOffice 4.0 which is very simple to use.

When you install SQL Anywhere 16 it comes with a 'demo' database and incidentally this has not changed from the earliest version to which I was exposed.

You can connect to the 'demo' server and create an ODBC connection as shown in the next image (note that you will be using a 32-bit driver):



Now launch OpenOffice 4.0 from its shortcut on the desktop and click Database as in the earlier post. You are already in Step 1.

In Step 2 select the demo ODBC connection and click OK.



In Step 3 provide 'dba' as username.


Click Test Connection. Provide 'sql' as the password.
Click OK.

You will see that you easily get connected.



In Step 4, save and proceed. For this example it was saved as SAP16.odf.



Now you see the Group O tables in the saved database.


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.