Setting an access (mdb file) datasource

Hi Milan
I have upgraded Lucee v4.5 to Lucee v5.
So, all jar files have been replaced by a single lucee.jar file in the
lucee/lib folder.

Then the ucanacees jar files do not exist anymore.

I tried to put the 2 files : ucanaccess-3.0.3.1.jar and hsqldb.jar
in lucee/lib

Then the error message changed and is :
Message com.healthmarketscience.jackcess.util.ErrorHandler
Cause

java.lang.ClassNotFoundException

Could you guide me for what can be done to retrieve
me access datasource with Lucee v5.

Thanks for your help.
Pierre.Le vendredi 22 janvier 2016 12:27:12 UTC+1, Milan Marković a écrit :

Are you sure you’re all jar copied to the folder where it was
old hypersonic-hsqldb.jar?

Milan

I’m just getting time out, any idea?On Tuesday, January 19, 2016 at 1:15:59 PM UTC-5, Pierre Larde wrote:

I tried to set an access (mdb file) datasource.
I have set a datasource in the Windows ODBC panel
Then I declared a datasouce in Lucee with JDBC-ODBC bridge
then I gave a name and the database name,
(I do not know what is the database name ? is that the ODBC created name)
And whatever database name I gave , i had this error :

can’t find class [sun.jdbc.odbc.JdbcOdbcDriver] for jdbc driver, check if
driver (jar file) is inside lib folder (cannot load class through its
string name, because no definition for the class with the specified name
[sun.jdbc.odbc.JdbcOdbcDriver] could be found)

It seems the JdbcOdbcDriver files are not found ?

Thanks for help.
Pierre.