node-db-oracle icon indicating copy to clipboard operation
node-db-oracle copied to clipboard
verified publisher icon mariano

TNS Support

Open digioi opened this issue 14 years ago • 1 comments

I added the following to the connection.

If you supply tnsname and the tnsname if ORACLE_HOME or TNS_NAMES is specified and the tnsname.ora file contains the tnsname supplied it will use the TNS Connection string

If you supply sid with the normal params it will format it as a TNS Connection string .

If it does not contain any tnsname or sid it will connect with your default connection.

  • Mike DiGioia

digioi avatar Dec 16 '11 22:12 digioi

I can confirm that the SID portion of this patch works with the following:

Database Server

  • Oracle Database 11g Release 11.1.0.0.0

Client OS

Mac OS X 10.6.8 (64-bit)

  • Oracle Instant Client 10.2.0.4 (64-bit)
  • Node.js v0.4.11 and v0.6.14

CentOS 6.2 (64-bit)

  • Oracle Instant Client 11.2.0.3.0 (64-bit)
  • Node.js v0.6.14

Thanks for submitting this patch!

acdvorak avatar Apr 02 '12 14:04 acdvorak