unixODBC: Connect to .mdb in Linux?

Background:

Ah!! Like all the things which you leave and try to forget about .. come back and haunt you . .. there was this old project I was doing .. .(Tags: PDF creation, Servlets JSP, XML parsing, XLS reading) in the year 2007. Of late due to some unforeseen circumstances I had to exhume it & find what the ghost wanted.

Well the UI looked professional and I started exploring it but for some reason Eclipse on my Windows didn’t quite work properly… SVCHOST was eating up all the CPU. So I had to give it a thought to migrate to Ubuntu. But there was this big blocker… ODBC on Unix….     [and the story continues ….]

Stuff I told synaptic to download:

mdbtools
unixODBC

Configuration done using this Link.

/etc/odbcinst.ini

[MDBToolsODBC]
Description = MDB Tools ODBC
Driver = /usr/lib/libmdbodbc.so.0
Setup =
FileUsage =
CPTimeout =
CPReuse =

/etc/odbc.ini

[logindb]
Description = Microsoft Access Try DB
Driver = MDBToolsODBC
Database = /home/nikunj/programming/logindb.mdb
Servername = localhost
Username =
Password =
port = 5432

Done?: (not yet)

nikunj@ubuntu-desktop:~$ isql logindb
+-------------------------------+
| Connected!
| sql-statement
| help [tablename]
| quit
+-------------------------------+
SQL> select name from profile
+-------------------------------+
| name
+-------------------------------+
| Mukesh Kumar Lahoti
| Nikunj Lahoti
| OneTwoThreeFour
| OneTwoThreeee
| M K Lahoti Ji
+-------------------------------+
SQLRowCount returns 5
5 rows fetched

Now [TODO]

1) Connect Java to this ODBC

2) Use MS Excel Connector for Unix+Java.
The Java Excel API is an open source Java API which allows Java developers toread Excel spreadsheets and to generate Excel spreadsheets dynamically.

Advertisements