connecting to a MS Access (mdb) database? [message #34571] |
Wed, 15 August 2007 20:38 |
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
|
|
|
Re: connecting to a MS Access (mdb) database? [message #34708 is a reply to message #34571] |
Thu, 16 August 2007 17:18 |
Eclipse User |
|
|
|
Originally posted by: brianf.sybase.com
Hi Jens!
This is unfortunately a common problem. The catalog loaders use default JDBC
functionality, and we've found that not all JDBC drivers are created
equally.
What you may need to do is create a new plug-in that contributes catalog
loaders for a MS Access database. You can look at some of the current DTP
Enablement plug-ins for some examples, including MS SQL Server, which had a
similar issue.
We unfortunately don't have the bandwidth to support every database out
there, but we would happily look at any contributions you may have to help
support MS Access for DTP Enablement.
Hope that helps!
--Fitz
Senior Software Engineer/Sybase, Inc.
DTP Connectivity
"Jens Ansorg" <jens@ja-web.de> wrote in message
news:f9vo7q$r7o$1@build.eclipse.org...
> 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
|
|
|
Re: connecting to a MS Access (mdb) database? [message #34742 is a reply to message #34708] |
Fri, 17 August 2007 10:33 |
Eclipse User |
|
|
|
Originally posted by: jens.ja-web.de
Brian Fitzpatrick wrote:
> Hi Jens!
>
> This is unfortunately a common problem. The catalog loaders use default JDBC
> functionality, and we've found that not all JDBC drivers are created
> equally.
>
> What you may need to do is create a new plug-in that contributes catalog
> loaders for a MS Access database. You can look at some of the current DTP
> Enablement plug-ins for some examples, including MS SQL Server, which had a
> similar issue.
>
> We unfortunately don't have the bandwidth to support every database out
> there, but we would happily look at any contributions you may have to help
> support MS Access for DTP Enablement.
>
> Hope that helps!
> --Fitz
ok,
thank you.
Jens
|
|
|
|
|
Re: connecting to a MS Access (mdb) database? [message #725822 is a reply to message #34742] |
Thu, 15 September 2011 21:27 |
|
I am having the same problem using the Sun/Oracle JDBC-ODBC driver (sun.jdbc.odbc.JdbcodbcDriver) to connect to a Microsoft Access database.
I would like to note that the BIRT project allows one to connect to a Microsoft Access Database above mentioned JDBC-ODBC Bridge. Is there any more development on this feature?
Thank you.
-Mark
|
|
|
Powered by
FUDForum. Page generated in 0.03833 seconds