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
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:
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.
Glad you found an solution