MS Access 2021, connection failure during New Database Connection on repository- Step 2/2

MAlex1 — Fri, 15 Nov 2024 21:31:42 GMT

Hello team,

I am facing some connection issues during the creation of DB connection (metadata) from MS Access 2021. In step 2/2 'Update Database Connection' when the 'Test connection' button is executed then this message will always appear: 'Connection failure. You must change the Database Settings.'

The meaning of the message is not clear to me.

'Connection failure. You must change the Database Settings.'

Details >>

java.lang.RuntimeException: net.ucanaccess.jdbc.UcanaccessSQLException: Illegal char <"> at index 0: "D:\sql_training.accdb"

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:208)

at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1170)

at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:317)

at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)

at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$75.runWithCancel(DatabaseForm.java:4556)

at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$75.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.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

at java.base/java.lang.Thread.run(Thread.java:833)

Caused by: net.ucanaccess.jdbc.UcanaccessSQLException: Illegal char <"> at index 0: "D:\sql_training.accdb"

at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:247)

at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:199)

... 9 more

Caused by: java.nio.file.InvalidPathException: Illegal char <"> at index 0: "D:\sql_training.accdb"

at java.base/sun.nio.fs.WindowsPathParser.normalize(WindowsPathParser.java:182)

at java.base/sun.nio.fs.WindowsPathParser.parse(WindowsPathParser.java:153)

at java.base/sun.nio.fs.WindowsPathParser.parse(WindowsPathParser.java:77)

at java.base/sun.nio.fs.WindowsPath.parse(WindowsPath.java:92)

at java.base/sun.nio.fs.WindowsFileSystem.getPath(WindowsFileSystem.java:232)

at java.base/java.io.File.toPath(File.java:2387)

at com.healthmarketscience.jackcess.DatabaseBuilder.toPath(DatabaseBuilder.java:457)

at com.healthmarketscience.jackcess.DatabaseBuilder.<init>(DatabaseBuilder.java:88)

at org.talend.ucanaccess.encrypt.CryptCodecOpener.open(CryptCodecOpener.java:14)

at net.ucanaccess.jdbc.DBReference.<init>(DBReference.java:158)

at net.ucanaccess.jdbc.DBReferenceSingleton.loadReference(DBReferenceSingleton.java:57)

at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:103)

... 11 more

===

org.talend.studio.tos.di.product ver. 8.0.1

azul Zulu JDK 17.42.19 (17.0.7.) 64-bit

Microsoft® Access® 2021 MSO (Version 2306 Build 16.0.16529.20164) 64-bit

===

Screenshots from Talend are attached.

Thanks for your time!

/MAlex

Re: MS Access 2021, connection failure during New Database Connection on repository- Step 2/2

Anonymous — Tue, 01 Aug 2023 07:33:46 GMT

Java 17 is not a supported Java version, for more details, please refer to installation guide.

please install Java 11 and try again.

Regards

Shong

Re: MS Access 2021, connection failure during New Database Connection on repository- Step 2/2

MAlex1 — Sun, 03 Sep 2023 14:14:45 GMT

Hello, thank you for the advice! Basically, I just wanted to connect to MS Access database and get the data and here I make do with the tAccessInput (tDBInput) component. In this case it works reliably even with Java 17.

Re: MS Access 2021, connection failure during New Database Connection on repository- Step 2/2

MAlex1 — Sun, 03 Sep 2023 14:39:00 GMT

Here is a description of what I needed and how I proceeded for those who will be dealing with a similar issue.

Basically, I only needed to connect to MS Access DB, and retrieve data from the table for further processing.

For this purpose, I used the 'tAccessInput' component in Job.

Here is the setting in the 'Component' view:

where 'User Name' and 'Password' are empty strings "", because I don't have login credentials set for DB.

What is essential, the scheme must be set - here:

and a basic SQL query that selects data from the required table:

"SELECT * from tbl_0001"

Here is the result of reading data from DB:

topic MS Access 2021, connection failure during New Database Connection on repository- Step 2/2 in Installing and Upgrading

MS Access 2021, connection failure during New Database Connection on repository- Step 2/2

Re: MS Access 2021, connection failure during New Database Connection on repository- Step 2/2

Re: MS Access 2021, connection failure during New Database Connection on repository- Step 2/2

Re: MS Access 2021, connection failure during New Database Connection on repository- Step 2/2