Cannot connect OpenOffice.org 2 to McKoi

Laurence Cooper

2006-06-05 11:48:50 UTC

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.

Post by Laurence Cooper
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
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/

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com