Main Menu

KB#01104-Notes regarding Basis Advantage Article - " OpenOffice.org - a Sweet New Suite"

Title:

Notes regarding Basis Advantage Article - " OpenOffice.org - a Sweet New Suite"

Description:

Q. I read the article about Open Office.org in the 20th Anniversary Edition of the BASIS Advantage magazine: 
http://www.basis.com/advantage/mag-v9n2/office.html 

I downloaded and installed OpenOffice and am having trouble configuring OOo Base so that it doesn't return an error. For the Datasource URL, I entered: 

basis:localhost?database=IHMSBBj;user=admin;pasword=admin123; 

Then I added 
com.basis.jdbc.BasisDriver 
to the JDBC Driver class. When I click on "Test Class", I get JDBC Driver Test: 

        The JDBC driver could not be loaded. 


What have I missed or am I doing wrong? 

Resolution:

First, confirm the JDBC Driver class JAR was added to your OpenOffice CLASSPATH. 
To do this, start OpenOffice.org (OOo): 

1. Go to Tools --> Options 
2. Expand the node under OpenOffice.org and select the Java node (at the bottom) 
Wait until your JVM shows up in the list. (This may take a few seconds.) 
3. Click the 'Class Path...' button. 
4. Click 'Add Archive' and then find the BBjJDBC.jar file and select it (so it is highlighted) 
5. Click OK until you are out of the options panel. 
6. Exit OpenOffice. Be sure to also close the OpenOffice quick start in the System Tray. 
(This is a VERY VERY IMPORTANT STEP!). 
7. Restart OpenOffice..org 

Once the above is done, OOo should be able to find the driver now. If you still have problems, reboot the computer, then go into OpenOffice again and see if that resolves the problem. 



Last Modified: 12/30/2005 Product: BBj

BASIS structures five components of their technology into the BBx Generations.

  Google+ View BASIS LinkedIN ProfileVisit our Twitter Feed Check out our Facebook Public Profile Click to View the BASIS youTube channel