Servoy & OpenOffice

Classic Servoy
1

Hello
My name is Juan Antonio Martín, I´m from Tenerife.
At the moment, I am beginning to use Servoy and I hope to contribute in every possible in this Forum.

My first question is.

Is possible use OpenOffice with Servoy or is necessary install a plug-in for it?.

Tranks.

2

What do you want to do/use from Open Office?

Our Data Plug-in (MS Excel) and Word Plug-in (MS Word) can read and create documents for MS Office and are useable by Open Office for that same reason.

Future support for PowerPoint should be possible as well.

3

It is worth noting that OOo can access the same data sources that your Servoy solutions are using. This allows you to use OOo to do things like print and mail merging, spreadsheets, charting, reports, etc with your data.

For Sybase, you need to include the sybase JDBC driver in the OOo class path (an easy thing to miss):

  • open OOo preferences > OpenOffice.org > Java
  • click “Class Path…”
  • click “Add Archive…”
  • choose “/Servoy/drivers/jconn3.jar”

I think the MySQL JDBC driver is included in a standard OOo install so no need to add that driver to the class path.

Now open the New Database Wizard:

  • choose “Connect to an existing database” option > JDBC
  • put the string “com.sybase.jdbc3.jdbc.SybDriver” into the “JDBC driver class” field and test. connection should be good.
  • copy the database server url from your Servoy database connection that you want to access and paste into the “Database URL” field. Remove duplicate “jdbc:” portion of the string. An example: “jdbc:sybase:Tds:localhost:2638?ServiceName=example&CHARSET=utf8”
  • go to the next screen and put in authentication stuff (defaults: user > dba and password > sql).
  • test the connection on this screen. if good proceed to the next screen to store the new connection and you’re done.