How to use tnsnames.ora in oracle node

[mhechthz]

Hi,

I found finally the only oracle node that seems to work on windows 7: node-red-contrib-oracledb-mod

But now I fail to connect to the data base because the tnsnames.ora is not found (I think so). I get following error:

"Oracle-server error connection to myDBserver:1554/P54: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"

PATH-variables for TNS_HOME and TNS_ADMIN are set properly and tnsnames.ora is in the admin directory.

Has anyone any idea of how to solve this? Getting Oracle work is a really hard task.

Thanks in advance.

[mhechthz]

Meanwhile I made some tests.

With node.js I can use the full Oracle connection string i.e.

(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = myDBserver)(PORT = 1554))(CONNECT_DATA =(SID = P54)))

via the dbconfig.js but in node-red I have to specifiy server, port and database, i.e. I cannot hand over the full configuration.