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

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

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:

Br,
Ivan

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

1 Like

Glad you found an solution :slight_smile:
Br,
Ivan