node.js - connecting nodejs to oracle -


i installed node-oracle these instructions: https://github.com/oracle/node-oracledb

however, i've been beating head against wall trying connect remote oracle database. i'm tapping community me out. have created different *.ora files (ldap.ora, sql.ora tns etc...) , set tns_admin directory files reside. bottom line have connection string:

jdbc:oracle:thin:@ldap://{hostname-1}:{portnumber}/{dbname},cn=oraclecontext,dc=world ldap://{hostname-2}:{portnumber}/{dbname},cn=oraclecontext,dc=world 

i can access database fine using oracle sql developer. i've had no sucess using sqlplus or node.

i've checked these (among many others):

https://community.oracle.com/thread/3759037

how connect ldap server using node-oracledb?

getting error while connecting oracle

ora-12560: tns:protocol adaptor error

has figured out yet , can post solution following:

  1. your jdbc connection string
  2. your sample *.ora files or whatever parameter you're passing oracledb.getconnection() node?

thanks,


Comments

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

javascript - jQuery UI Splitter/Resizable for unlimited amount of columns -

javascript - IE9 error '$'is not defined -