I want to be able to use nodejs to connect to Oracle 11g database. I have only seen connectivity with 9i, though would like to know how to be able to use it under a Windows environment.
3 Answers
Module oracle is the most updated and feature rich Oracle driver in npm. It supports 11g version as well.
Comments
install required tools
- VS2012(express edition as well, I choosed this)
- python2.7(add to path)
- nodejs
- Oracle11g
add the oracle driver to system environment path:
OCI_LIB_DIR=C:\oracle\product\11.2.0\dbhome_1\oci\lib\msvc OCI_INC_DIR=C:\oracle\product\11.2.0\dbhome_1\oci\include
npm install oracledb
Then you can connect oracle with nodejs.
My OS is Win8 64bit.
Comments
If you are comfortable in C#, an option is to call .NET in-process and leverage .NET's mature database ecosystem. Refer my answer here.