I need to connect to an MS Access data source using oXygen XML editor. I have had this working on a windows computer last year, however, I am having trouble connecting this on Ubuntu 11.04. It continually returns java.sql.SQLException: null




I feel like it is a simple solution, but I am stumped and have spent too much of my work day on this. Has anyone encountered this before, or has any advice to offer?


What I have Done:

In <oXygen/>
1. Configured JDBC-ODBC Bridge


2.Configured Connection


In Ubuntu 11.04
1. Added a link to a file-system client based on ssh
Code:
sshfs -p22 matt@192.168.1.196:/productionFolder /media/productionServer
2. Added Microsoft Access Driver to odbcinst.ini
Code:
$ cat /etc/odbcinst.ini 
[Microsoft Access Driver]
Description =   MDB Tools ODBC drivers
Driver = /usr/lib/libmdbodbc.so.0
Setup = /usr/lib/libmdbodbc.so.0
FileUseage = 1
3. Added ODBC connection to odbc.ini[/list]
Code:
$ cat /etc/odbc.ini 
[production]
Driver  =   Microsoft Access Driver
Description =   Production ODBC Connector
Trace   =   Yes
TraceFile   =   /tmp/odbc.log
Database    =   /media/productionServer/Production/production--00.mdb
4. Tested the connection
Code:
$ isql -v production 
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> quit
And Yet, in oXygen It still returns with java.sql.SQLException: null