jdbc driver for MS Access 64 bit

[Steve James]

Hi I am trying to get Ebase to connect to an MS Access database (not entirely through choice).

Using the MS Access database type I get "cannot load library: c:\program files\infozoom\izmjniado.dll"

I've tried looking for other options and sun.jdbc.odbc.JdbcOdbcDriver seems to be another way to go but I get "No suitable driver". As I understand it the driver should be included in the jre?

Anyone got any experience of this?

Thanks

[Jon]

The dll file is in OptionalLibraries/jadozoom of the Ebase distribution. You need to copy this and the licence file. See http://www.ebasetech.com/ebase/doc/URL_ ... c410653901. Should work then.

[Steve James]

Thanks Jon. but...

"could not load izmjniado.dll C:\Program Files\infozoom\izmjniado.dll: Can't load IA 32-bit .dll on a AMD 64-bit platform"

We are running Windows Server 2012 64bit.

[Jon]

I came across this advice..

If you use a 64-bit version of Windows, you should also place izmjniado.dll in C:\Windows\SysWOW64\

Make sure overwrite any existing files_new (but make a backup copy of the original file).

Reboot your computer.

[Steve James]

Hi same whinge.

Thanks

[Steve James]

Hi I did some more research and it appears that sun.jdbc.odbc.JdbcOdbcDriver was removed from Java 8.

Thanks

[Jon]

Here is a 64 bit version of the jadozoom driver. Please unzip and see the readme file - this contains instructions on licensing which I'm hoping you can ignore i.e. just copy the DLL to an appropriate system library and the jar file to tomcat/lib replacing the existing izmado.jar. I'm not sure whether this has been tested so any feedback gratefully appreciated.
http://www.ebaseftp.com/download/forum/izmado64.zip

There also appears to be an alternative to jadozoom called jackcess or UcanAccess but we have no experience of using this and it has some jar dependencies that may be problematic http://ucanaccess.sourceforge.net/site.html

[Steve James]

Hi Jon, thanks for that.

I've copied the files and restarted Ebase. Progress in that it is now whinging about an invalid licence.

I've always thought that connection to MS Access was via the Ebase licence. We've not connected to MS Access for some time now. That said we now have a requirement to get at MS Access database tables.

Thanks

[Jon]

The jadozoom JDBC driver has its own licensing and you may be having a problem with that. If you are following the instructions in the Ebase doc you will have a JDBC URL with parameter IzmRoyaltyFree=nnnnn. Can you try removing this parameter - I think this number is tied to the xxx.LIC file which is part of the Ebase distribution and you've previously copied to a system library.

[Steve James]

Hi Jon, I've tried with and without the IzmRoyaltyFree and get the same error message.

Thanks

[Jon]

OK, we will try and sort this out with the jadozoom supplier. This might take a few days.

[Steve James]

Thanks Jon

[Jon]

Here is the JDBC driver for 64-bit versions of MS Access: http://www.ebaseftp.com/download/forum/jadozoom64.zip. This has been tested with 64 bit MS Access 2016 on Windows 10 but should work for other 64 bit combinations.

Installation:
1. Unzip
2. Copy files izmjniado64.dll and 13101201.LIC to a library on the system path e.g. C:\Windows\System32. Alternatively these files can be copied to C:\Program Files\infozoom.
3. Copy izmado64.jar to UfsServer\tomcat\lib and remove izmado.jar if it exists
4. Restart the Ebase server

JDBC Url example:
jdbc:izmado64:Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:/Users/jonri/Documents/Database1.accdb;IzmRoyaltyFree=541321978;

The provider string may need to be changed for different versions of MS Access or the Access Database Engine Redistributable to 14.0, 15.0 etc.

The IzmRoyaltyFree property must be added as above.

[Steve James]

Thanks Jon. Good timing I've got 200+ mdb files to process.

Unfortunately the link to the zip file is 404.

Thanks

[Jon]

That's a lot! I've fixed the link.

[Steve James]

Tell me about it. It's 1 mdb per polling district. That said it'll certainly give the Access driver a good test

I think I can get at better data but I need to understand the data first.

[dvanhussel]

I can feel your pain, working with Access...but it could be worse:

In upcomming elections, local government in the Netherlands is 'not allowed to use any software to count'. In order to prevent hacking

https://translate.google.com/translate? ... t=&act=url

[Steve James]

Yes I heard that in the news today.

You know things are bad if you have to use carrier pigeons to carry the voting cards to the count centre.