Eclipse Community Forums: DTP » connecting to a MS Access (mdb) database?

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

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 13: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 06: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 #587288 is a reply to message #34571]

Thu, 16 August 2007 13:18

Eclipse User

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 #587305 is a reply to message #34708]

Fri, 17 August 2007 06:33

Eclipse User

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 17:27

Eclipse User

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

Previous Topic:	Would like to contribute my fix to the open source DTP plugins
Next Topic:	DTP - Unable to identify some datatypes

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Nov 02 18:55:47 EST 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter