Geek Answers Handbook

How to connect Oracle 11g with nodejs on Windows?

I want to be able to use nodejs to connect to an Oracle 11g database. I have only seen a connection with 9i, although I would like to know how to use it in a Windows environment.

+4
source share
3 answers

The oracle module is the most updated and feature-rich Oracle driver in npm. It supports version 11g.

+3
source

  • install the necessary tools

    • VS2012 (express edition also, I chose this)
    • python2.7 (add to path)
    • nodejs
    • Oracle11g

  • add the oracle driver to the 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.

Source: github node -oracledb

+1
source

If you're comfortable in C #, the option is to call .NET in the process and use the ecosystem of the mature .NET ecosystem. Post my answer here .

0
source

More articles:


All Articles