|connecting to a MS Access (mdb) database? [message #587219]
||Wed, 15 August 2007 20:38
| Jens Ansorg
Registered: July 2009
I need to work with a access database file. I know how to do that in
java code. But I would like to use the eclipse data tools to write/test
some queries against the database. What I did so far:
- Set up a odbc connection in Windows that uses the ms access driver and
points to the database file (the data source I use from java code)
- created a new Driver Definition and called it "ODBC JDBC driver". This
driver definition points to the jre/rt.jar and uses the
- created a connection using the new Driver Definition, pointing to the
When I press "test connection" I get a "Ping suceeded!" message
Ok. Database created.
But when I actually "connect" to the database I get an empty "Schemas"
folder and nothing else :(
Where is the mistake? How can I work with access database?
Powered by FUDForum
. Page generated in 0.12535 seconds