Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » connecting to a MS Access (mdb) database?
connecting to a MS Access (mdb) database? [message #587219] Wed, 15 August 2007 16:38
Jens Ansorg is currently offline Jens Ansorg
Messages: 2
Registered: July 2009
Junior Member
hi,

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
"sun.jdbc.odbc.JdbcOdbcDriver"

- created a connection using the new Driver Definition, pointing to the
odbc source.

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?


thanks
Jens
Previous Topic:Generate DBUnit Dataset Does nothing
Next Topic:50 records returned
Goto Forum:
  


Current Time: Wed Aug 27 09:19:05 EDT 2014

Powered by FUDForum. Page generated in 0.01890 seconds