jdbc driver for MS Access 64 bit
Moderators: Jon, Steve, Ian, Dave
-
- Ebase User
- Posts: 331
- Joined: Mon Mar 10, 2014 8:34 am
jdbc driver for MS Access 64 bit
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
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
0 x
-
- Moderator
- Posts: 1342
- Joined: Wed Sep 12, 2007 12:49 pm
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.
0 x
-
- Ebase User
- Posts: 331
- Joined: Mon Mar 10, 2014 8:34 am
-
- Moderator
- Posts: 1342
- Joined: Wed Sep 12, 2007 12:49 pm
-
- Ebase User
- Posts: 331
- Joined: Mon Mar 10, 2014 8:34 am
-
- Moderator
- Posts: 1342
- Joined: Wed Sep 12, 2007 12:49 pm
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
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
0 x
-
- Ebase User
- Posts: 331
- Joined: Mon Mar 10, 2014 8:34 am
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
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
0 x
-
- Moderator
- Posts: 1342
- Joined: Wed Sep 12, 2007 12:49 pm
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.
0 x
-
- Ebase User
- Posts: 331
- Joined: Mon Mar 10, 2014 8:34 am
-
- Moderator
- Posts: 1342
- Joined: Wed Sep 12, 2007 12:49 pm
-
- Moderator
- Posts: 1342
- Joined: Wed Sep 12, 2007 12:49 pm
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.
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.
Last edited by Jon on Thu Feb 02, 2017 9:27 am, edited 1 time in total.
0 x
-
- Ebase User
- Posts: 331
- Joined: Mon Mar 10, 2014 8:34 am
-
- Ebase User
- Posts: 331
- Joined: Mon Mar 10, 2014 8:34 am
- dvanhussel
- Ebase User
- Posts: 161
- Joined: Fri Oct 19, 2007 12:45 pm
- Location: Haarlem, the Netherlands
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
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
0 x
-
- Ebase User
- Posts: 331
- Joined: Mon Mar 10, 2014 8:34 am
Who is online
Users browsing this forum: No registered users and 110 guests