Re: Cannot connect OpenOffice.org 2 to McKoi

Further to my previous post, here is the procedure for connecting 
OpenOffice.org 2.0 to McKoi database

Adding McKoi jdbc drivers (this also applies to other jdbc drivers):

1.      Make sure you have the java vm setup
2.      Tools->options: Openoffice.org->Java
3.      Click 'Classpath' button
4.      Click 'Add Archive' button
5.      Browse for 'mkjdbc.jar'
6.      Click 'OK'
7.      Click 'OK'
8.      Shutdown OpenOffice.org
9.      Start OpenOffice.org Base
10.     Select 'Connect to an existing database'
11.     In 'Datasource URL' textbox add 'mckoi://localhost/' (jdbc: is implied)
12.     In 'JDBC Driver Class' textbox add
13.     Click on 'Test class' button.
         An information dialogue will be displayed, giving result of test.
         If successful, then
14.     Click 'Next' ...
15.     Enter username.
         Tick 'Password required' checkbox, if necessary.
16.     Click 'Test Connection' button.
         Enter password, if necessary.
         If test is successful, then ...
17.     Select options to proceed, and click Finish.


At 18:09 01/06/2006, you wrote:
>Hi
>
>I am trying to connect to McKoi DB (installed locally) using 
>OpenOffice.org 2.0 Base under Windows 2000.
>
>I have entered the following database URL: mckoi://localhost/
>and the JDBC driver class: com.mckoi.JDBCDriver
>
>When I click on 'Test Class' button, I get the following error message: 
>The JDBC driver could not be loaded.
>
>Do I need to extract the driver from the mkjdbc.jar file?
>Or do I need to put it into the class path?  If so, how would I do that?
>Or, is there something else that I am missing?
>
>Any help would be much appreciated.
>
>Thanks in advance.
>
>
>---------------------------------------------------------------
>Mckoi SQL Database mailing list  http://www.mckoi.com/database/
>To unsubscribe, send a message to [email protected]


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]