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 20:38 Go to next message
Eclipse UserFriend
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 Go to previous messageGo to next message
Eclipse UserFriend
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 Go to previous messageGo to next message
Eclipse UserFriend
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 17:18 Go to previous messageGo to next message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
Messages: 495
Registered: July 2009
Senior Member
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 10:33 Go to previous messageGo to next message
Jens Ansorg is currently offline Jens AnsorgFriend
Messages: 2
Registered: July 2009
Junior Member
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 Go to previous message
Mark Sluser is currently offline Mark SluserFriend
Messages: 15
Registered: June 2011
Location: Calgary
Junior Member
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:
  


Current Time: Fri Nov 28 07:27:46 GMT 2014

Powered by FUDForum. Page generated in 0.01739 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software