|By Jayaram Krishnaswamy||
|September 24, 2013 06:39 AM EDT||
When SQL Anywhere 16 is accessed by OpenOffice 4.0 using an ODBC connection, the problem of viewing table contents is not yet settled as described in the previous two posts here:
However, a work around was found and was described in this post:
From earlier posts we have seen that OpenOffice 4.0 provides couple of different options to access data. We start as in earlier posts by launching OpenOffice 4.0 as shown here. It is assumed that the SQL Anywhere 4.0 sample database 16.0 has started and that you can connect to the database from Sybase Central 16.0
We have chosen to connect to SQL Anywhere using the ADO connection as shown above.
In Step 2 we need to set up the ADO connection for which we need to provide an URL. I have used demo as the URL (not strictly follows the definition of an URL, which is, Internet address: an address identifying the location of a file on the Internet, consisting of the protocol, the computer on which the file is located, and the file's location on that computer).
This was a guess on my part looking at the Personal Server shown here:
Clicking Next on the OpenOffice 4.0 Database Wizard screen brings up the following wherein User authentication must be set up:
After entering the Password (sql) click OK.
You get a confirmation from OpenOffice Base as shown above.
We have come to Step 4. Accept the defaults as above and click Finish.
- Where Are RIA Technologies Headed in 2008?
- PowerBuilder History - How Did It Evolve?
- Creation and Consumption of Web Services with PowerBuilder
- Cloud People: A Who's Who of Cloud Computing
- DDDW Tips and Tricks
- Working with SOA & Web Services in PowerBuilder
- Cloud Expo 2011 East To Attract 10,000 Delegates and 200 Exhibitors
- Dynamically Creating DataWindow Objects
- OLE - Extending the Capabilities of PowerBuilder
- DataWindow.NET How To: Data Entry Form
- Custom Common Dialogs Using SetWindowsHookEx
- Cloud Expo and The End of Tech Recession
- Solutions for Optimizing ASP.NET Applications
- Dynamic SQL
- Office 2003 Toolbar: A New Look For Your Old PowerBuilder App