Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    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 11:46 Go to next message
Fred van Rijswijk is currently offline Fred van RijswijkFriend
Messages: 2
Registered: July 2015
Junior Member
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 19:31 Go to previous messageGo to next message
Jerry Sheets is currently offline Jerry SheetsFriend
Messages: 76
Registered: July 2009
Location: Salt Lake City, UT
Member
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 08:10 Go to previous messageGo to next message
Fred van Rijswijk is currently offline Fred van RijswijkFriend
Messages: 2
Registered: July 2015
Junior Member

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 19:45 Go to previous message
Erik Emilio Flores Delfin is currently offline Erik Emilio Flores DelfinFriend
Messages: 1
Registered: June 2018
Junior Member
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: Fri Mar 29 11:51:51 GMT 2024

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

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

Back to the top