Had anyone connected to a HPE NonStop SQL/MX database

KNIME Analytics Platform
1

We have a HPE NonStop SQL/MX database managed by a third party which currently we access using ODBC via a convoluted route using KNIME to run external PHP scripts. We do now have a JDBC connector available and I registered the jar in the database preferences and all seems OK in the JDBC connector with DB URL like jdbc:t4sqlmx://10.43.52.60:6000/NEC. I get an error when trying to connect this, to the tune of ‘Invalid authorization specification’ - this using the username and pw which work with the ODBC connection. Maybe we need different credentials for the JDBC option but I would have thought these were DB specific rather than connection… Still digging of course but wondering if anyone out there has sorted this already and can save us some time.

2

Hi @SteveThornton,

Thank you so much for posting your query on the forum. I am not aware of what third party service is being used. However, what I can point you to are several resources, maybe those can be of help to you:

Hope it helps

Thanks

Best,
Ali

1 Like
3

Thanks for this but doesn’t really help for this specific case - will post an update if and when we make any progress…

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.