connecting to a MS Access (mdb) database? [message #587219] |
Wed, 15 August 2007 20:38 |
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
|
|
|
Powered by
FUDForum. Page generated in 0.03481 seconds