Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » Connecting a MS Access database using java 8(I can not connect to a mdb or accdb. Accessing XML-files works fine.)
Connecting a MS Access database using java 8 [message #1702735] Fri, 24 July 2015 07:46 Go to next message
Eclipse UserFriend
Running Windows 8 on a 64bit laptop. Latest Birt Report Designer and Java 8. All updated to current date.


Is it possible to connect Birt to a MS-access database?

Regards.



PS. Done sofar:
Created ODBC TestDB with DSN:c:\birt\test.accdb
Downloaded multiple jars to
C:\eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_4.5.0.v201506092134\drivers\rt.jar .
New jdbc datasource.
Select sun.jdbc.odbc
jdbc:odbc:TestDB
Test Connection is OK but: after jdbc:odbc: i can type anything i want (or nothing). It is all 'Test succesfull).
New Dataset: I can select the datasource but i does not show any available items.
Re: Connecting a MS Access database using java 8 [message #1703344 is a reply to message #1702735] Thu, 30 July 2015 15:31 Go to previous messageGo to next message
Eclipse UserFriend
I found a 3rd Party MS Access JDBC Driver from a Google search. I downloaded and tried the free trial version. It worked fine but we opted not to purchase the full version and went a different route. If you don't find it, let me know and I'll see if I can track down the name of the product we tested.
Re: Connecting a MS Access database using java 8 [message #1703377 is a reply to message #1702735] Fri, 31 July 2015 04:10 Go to previous messageGo to next message
Eclipse UserFriend

Problem solved.

I end up with:
Driver Class: com.caigen.sql.access.AccessDriver ( v5.2)
Database URL: jdbc:access:/C:/BIRT/Test2.accdb

No there was NO ODBC needed.
Re: Connecting a MS Access database using java 8 [message #1790284 is a reply to message #1703377] Thu, 07 June 2018 15:45 Go to previous message
Eclipse UserFriend
Sorry, I was wondering if you can provide the file or a link to the library itself?

Thanks in advance.
Previous Topic:how to integrate BirtViewer Content into a bootstrap template (php/html web application))
Next Topic:Birt Report 3.2.22 fails in 4.3
Goto Forum:
  


Current Time: Wed Mar 19 16:43:13 EDT 2025

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly