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 #34571] Wed, 15 August 2007 16:38 Go to previous message
Eclipse User
Originally posted by: jens.ja-web.de

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

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic:Would like to contribute my fix to the open source DTP plugins
Next Topic:DTP - Unable to identify some datatypes
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 22 21:16:14 EDT 2013

Powered by FUDForum. Page generated in 0.02069 seconds