No Access DB 2010 (*.accdb) access from TOS 6.3

ThomasPit — Mon, 23 Jan 2017 17:28:06 GMT

Hi
I have problem to access MS-Access 2010 Database (*.accdb). Accessing older MS-Access DB (*.mdb) works fine.
When I try to access MS-Access 2010 Database (*.accdb) I get the following error:

  java.lang.RuntimeException: net.ucanaccess.jdbc.UcanaccessSQLException: user lacks privilege or object not found: NULL
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1092)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$59.runWithCancel(DatabaseForm.java:3812)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$59.runWithCancel(DatabaseForm.java:1)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
      at java.util.concurrent.FutureTask.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)

OS: Windows Server 2010
Talend: 6.3.0 (TOS_DI-win-x86_64)
Java: java.version=1.8.0_111

Any idee?

Thomas

Re: No Access DB 2010 (*.accdb) access from TOS 6.3

ThomasPit — Thu, 26 Jan 2017 06:52:00 GMT

Hi
Up to now I didn't get any suggestion/Solution on my problem.
Is the answer to hard or are there no solutions?

Please help.
Thomas

Re: No Access DB 2010 (*.accdb) access from TOS 6.3

_AnonymousUser — Thu, 26 Jan 2017 10:47:45 GMT

Hi Thomas,
Instead of leaving the user and password fields empty, you can try to enter an empty string: ""
Best regards
Olivier

topic Re: No Access DB 2010 (*.accdb) access from TOS 6.3 in Talend Studio

No Access DB 2010 (*.accdb) access from TOS 6.3

Re: No Access DB 2010 (*.accdb) access from TOS 6.3

Re: No Access DB 2010 (*.accdb) access from TOS 6.3