JavOO

JavOO : Java Odbc for Office.

Introduction

JavOO is a small multithread secure server written in Java and working on Windows platform.

It allows you to share MSAccess and MSExcel resources, which will be accessed through the native ODBC driver of Windows.

Download

The actual version is beta 1.0 .

You can download the Windows installer here.

Installation

Double-click on the file JavOOsetup.exe and follow the instructions.

By default the program will be installed in the directory C:\Program Files\JavOO\ .

Configuration

Now that you've installed JavOO, you need to add your Excel and/or Access resources.

In the install directory you'll find a file named javooconfig.xml. Edit this file with you favorite text editor.

Excel file

  <excel_resource name="testExcel" 
                   filepath="C:/path/to/the/file.xls" 
                   sheet="sheet" 
                   selection="selection" 
                   user="username" 
                   password="userpassword" 
                   readonly="true" />

Access file

  <access_resource name="testAccess" 
                    filepath="C:/path/to/the/file.mdb" 
                    user="username" 
                    password="userpassword" 
                    readonly="true" />

Usage

Here is a screenshot of the JavOO application:

Error creating thumbnail: Unable to save thumbnail to destination

1. STOP button: Stop the server, deconnecting all clients.
2. START button: Start the server, the server is ready to accept connections from clients.
3. Server Log Area: Some actions executed by the server are logged in this text area.
4. Clear button: This button clears the Server Log Area (3).
5. Save button: This button will be used for further development.
6. Config button: This button will be used for further development.
7. Test Client button: This button is used to test the server, the result output of the test will be shown in the Server Log Area (3).