Does anybody have examples, documentation on using the JDBC Driver in Open Office?
Many Thanks Bjorn -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ian Stuart Sent: 10 May 2005 09:25 To: u2-users@listserver.u2ug.org Subject: [U2] OpenOffice.org 1.9.100 and UniVerse JDBC For anybody who is interested OpenOffice.org have made changes to support some of the "anomolies" in the UniVerse JDBC driver. This now means that those users wanting to deploy Linux on the desktop either as a thin-client or full installation can use a very functional end-user database and Office Suite tool to retrieve data from a UniVerse database into OpenOffice.org reports, documents, spreadsheets, presentations and databases. You don't need Microsoft to be Microsoft compatible either. The "patch" is provided by OpenOffice.org via a macro that needs to be run after creating the data source. Unfortunately the User Interface for OpenOffice.org 2.0 has already been defined and this patch has to be run manually until it is built into the product. However it is very easy to implement. It's been really great working with the people at OpenOffice.org, many who appear to be employed by Sun Microsystems. They have off their own bat downloaded Personal editions of UniVerse and with a little help and persistent pleas for their support, have over the last year or so implemented a number changes to OpenOffice specifically to cater for UniVerse. I am amazed at the willingness of the OpenOffice people to respond to queries, suggestions and reports of issues relating to a database that is little known as far as they are concerned when I compare this to the inertia from IBM on this issue over the same period. Although OpenOffice might not suit everybody it is one of the largest and most successful Open Source projects to tackle Microsoft right where it hurts and one would have thought that IBM, as part of their stated strategy, would see the benefits of providing the SMB market with the tools to cut costs whilst deploying UniVerse for the core applications. After all, how much of Microsoft Office is actually used by the average user - OpenOffice 2.0 addresses issues of document portability and compatibility issues with Microsoft to a very large degree. Anyway, apart from some anomolies related to file names which can be catered for by either manully editing the SQL or by creating synonymns , the query and reporting tool works well on both Windows and Linux using JDBC. Unfortunately ODBC support for UniVerse has still to be resolved as OpenOffice.org has been built around ODBC 3.0 - perhaps an IBM engineer would make contact with the right people at OpenOffice - if they need the names/email addresses that can be arranged. If anybody wants to try this out and needs help, feel free to contact me Ian Stuart ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/