How to map to a OneDrive (long address with spaces and "-" and ":")

[mvdzant]

Hi, I would like to store a database URL in Database Connector Node

The address contains a lot of spaces and special characters ("-" , “:”) minus sign and semi column
I’m not sure whether Knime can handle this?

The address jdbc:ucanaccess://c:\Users\zantm\ OneDrive - Xxxx Xxxxxx Xxxxx XXX: Xxxxxxx Xxx

Please advice
Menno

[ipazin]

Hi there!

Don’t see why KNIME couldn’t handle it but best would be to try it out and see. Maybe this topic can help you regarding general access to Microsoft Access database:

How to connect to MS Access Database

Hi, here are the steps you need to perform to connect to a MS Access database with KNIME Analytics Platform: Download the UCanAccess JDBC driver by clicking on this link Extract the downloaded zip file to a folder on your local hard drive Create a new folder e.g. UCanAccess on your hard drive Copy from the extracted folder the following files into the new created folder (see driverFiles.PNG): ucanaccess-4.0.3.jar (located in the root folder) commons-lang-2.6.jar (located in the lib…

Br,
Ivan

[mvdzant]

Hi Ivan,

Thanks for your answer. I have resolved my issue. Had to do with correct hostname what can be retrieved on the command prompt through “cmd” finding my computer name.

Thanks.
Menno

[ipazin]

Glad you found an solution
Br,
Ivan