4

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 3

3

Module oracle is the most updated and feature rich Oracle driver in npm. It supports 11g version as well.

Sign up to request clarification or add additional context in comments.

Comments

1
  1. install required tools

    1. VS2012(express edition as well, I choosed this)
    2. python2.7(add to path)
    3. nodejs
    4. Oracle11g
  2. 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

  3. npm install oracledb

Then you can connect oracle with nodejs.

My OS is Win8 64bit.

Source : github node-oracledb

Comments

0

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.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.