search

node-red-contrib-ibm-cloud / node-red-contrib-ibm-db2

Node-RED nodes to work with a Db2 LUW database. Works with "Db2 on Cloud" and "Db2 Warehouse on Cloud" services as well as standalone installation of Db2 LUW.
2 stars 1 forks source link

cannot connect to enterprise plan of Db2 #2

Open Ayumu-walker opened 3 years ago

Ayumu-walker commented 3 years ago

I have a question about node-red-cotrinb-ibm-db2. This node cannot connect to Db2 on the enterprise plan. I checked the code and the function _getDb2config(n) is supposed to get the credentials for the light plan. But the connection cannot be made because the credentials of structure of the Enterprise plan are different from the Light plan.

I get the following message. Db2 query node, error connecting: Error: [IBM][CLI Driver] SQL1337N The service "undefined" was not found.

I want to be able to connect to both plans. Do you plan to fix this one?

knolleary commented 3 years ago

Moving this issue over to the db2 nodes repository now that I've enabled issues on it.

smchamberlin commented 3 years ago

Hi Ayumu-walker, it should work with enterprise plan. Can I please get some more information from you: Are you using "Db2 On Cloud" or "Db2 Warehouse On Cloud"? We have tested with Db2oC Enterprise with successful connection. Did you connect the service to an IBM-hosted app? (Is it cloud foundry app?). Did you connect the service before or after your Node-RED app was deployed? (If after, have you tried redeploying?). Thanks.