Beta Oracle9i connection failure

juli · General User Joined: 11 Apr 2005 Posts: 9

Using OOO beta version in Windows I succesfully connect with Oracle 9i using JDBC.
But it fails in Linux 2.4 (Red Hat).
Connection Test results is "The connection could not be established successfully"
Any idea?

jww29 · Newbie Joined: 05 Jan 2007 Posts: 4 Location: Kansas US

Do you have the path for the JDBC driver set in open office? I am getting a simular error in windows xp trying to connect the Oracle 9i to openoffice base 2.2

DrewJensen · Posted: Thu Apr 26, 2007 11:46 am Post subject:

Version 2.2 has some serious problems with many of the JDBC connections. The developers released a patched file for the problem - it is not an official release - but in my case it cleared up a number of issues and seems to have added NO new ones ( always the concern ).

You can get a copy of this file for both Windows and Linux ( It is for OOo 2.2.0 - I have no idea what 2.4 on Red Hat relates to in the standard OOo release numbers so can't say if it would work or not.)

The file can be found at

http://dba.openoffice.org/servlets/ProjectDocumentList go to the Unsupported Diagnose Tools

The file for Windows is under the entry named i74732.fix.ooo22.windows, for linux i74732.fix.ooo22.linux

What the heck this is a user community that has lots of folks using Operating Systems that go by the name 'Unstable'...so why not use an unsupported file.

Anyway, not sure it will help your problem but it is worth a try.

EDIT - Be sure to backup the file in your installation before you replace it with this one, just in case.
Drew Jensen
_________________
Blog - http://baseanswers.spaces.live.com/