By Jayaram Krishnaswamy | Article Rating: |
|
September 24, 2013 06:39 AM EDT | Reads: |
831 |

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:
http://hodentek.blogspot.com/2013/08/do-you-need-to-connect-to-sql-anywhere.html
http://hodentek.blogspot.com/2013/09/do-you-need-to-connect-to-sql-anywhere.html
However, a work around was found and was described in this post:
http://hodentek.blogspot.com/2013/09/do-you-need-to-connect-to-sql-anywhere_20.html
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.
Click OK.
We have come to Step 4. Accept the defaults as above and click Finish.
Read the original blog entry...
Published September 24, 2013 Reads 831
Copyright © 2013 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.
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.
- 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
- Cloud Expo 2011 East To Attract 10,000 Delegates and 200 Exhibitors
- Working with SOA & Web Services in PowerBuilder
- Cloud Expo, Inc. Announces Cloud Expo 2011 New York Venue
- Dynamically Creating DataWindow Objects
- Cloud Expo and The End of Tech Recession