For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Hi, how can i do the following example? i want Add new cusomer button after refresh list box. Thanks https://apex.oracle.com/pls/apex/f?p=72834:2
Hi,
I am done with installing the prerequisites but while running the npm, I am facing the below error. Could you please help?
Building the projects in this solution one at a time. To enable parallel build
please add the "/m" switch.
C:\Program Files (x86)\MSBuild\Microsoft.Cpp\v4.0\V110\Microsoft.Cpp.Platform.
argets(44,5): error MSB8020: The builds tools for v120 (Platform Toolset = 'v1
0') cannot be found. To build using the v120 build tools, either click the Pro
ect menu or right-click the solution, and then select "Update VC++ Projects...
. Install v120 to build using the v120 build tools. [C:\Users\Rao\AppData\Ro
ming\npm\node_modules\oracledb\build\oracledb.vcxproj]
gyp ERR! build error
gyp ERR! stack Error: `msbuild` failed with exit code: 1
gyp ERR! stack at ChildProcess.onExit (C:\Program Files (x86)\nodejs\node_
dules\npm\node_modules\node-gyp\lib\build.js:269:23)
gyp ERR! stack at ChildProcess.emit (events.js:110:17)
gyp ERR! stack at Process.ChildProcess._handle.onexit (child_process.js:10
:12)
gyp ERR! System Windows_NT 6.1.7601
gyp ERR! command "node" "C:\\Program Files (x86)\\nodejs\\node_modules\\npm\\n
e_modules\\node-gyp\\bin\\node-gyp.js" "rebuild"
gyp ERR! cwd C:\Users\Rao\AppData\Roaming\npm\node_modules\oracledb
gyp ERR! node -v v0.12.7
gyp ERR! node-gyp -v v2.0.1
gyp ERR! not ok
npm ERR! Windows_NT 6.1.7601
npm ERR! argv "C:\\Program Files (x86)\\nodejs\\\\node.exe" "C:\\Program Files
x86)\\nodejs\\node_modules\\npm\\bin\\npm-cli.js" "install" "oracledb" "-g"
npm ERR! node v0.12.7
npm ERR! npm v2.11.3
npm ERR! code ELIFECYCLE
npm ERR! oracledb@1.5.0 install: `node-gyp rebuild`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the oracledb@1.5.0 install script 'node-gyp rebuild'.
npm ERR! This is most likely a problem with the oracledb package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR! node-gyp rebuild
npm ERR! You can get their info via:
npm ERR! npm owner ls oracledb
npm ERR! There is likely additional logging output above.
npm ERR! Please include the following file with any support request:
npm ERR! C:\Users\Rao\npm-debug.log
****UPDATE: SOLVED!! *****
Issue fixed after doing below steps. Thanks to Pomodory and his links!
1) Add a user variable "ToolPath" as "C:\Program Files (x86)\MSBuild\12.0\Bin". I think this is required. No matter what I install this did not get added to PATH automatically.
2) Add a user variable "GYP_MSVS_VERSION" as 2013
3) Add the path "C:\Program Files (x86)\MSBuild\12.0\Bin" to PATH variable.
Hi,I am done with installing the prerequisites but while running the npm, I am facing the below error. Could you please help?Building the projects in this solution one at a time. To enable parallel buildplease add the "/m" switch.C:\Program Files (x86)\MSBuild\Microsoft.Cpp\v4.0\V110\Microsoft.Cpp.Platform.argets(44,5): error MSB8020: The builds tools for v120 (Platform Toolset = 'v10') cannot be found. To build using the v120 build tools, either click the Proect menu or right-click the solution, and then select "Update VC++ Projects.... Install v120 to build using the v120 build tools. [C:\Users\Rao\AppData\Roming\npm\node_modules\oracledb\build\oracledb.vcxproj]gyp ERR! build errorgyp ERR! stack Error: `msbuild` failed with exit code: 1gyp ERR! stack at ChildProcess.onExit (C:\Program Files (x86)\nodejs\node_dules\npm\node_modules\node-gyp\lib\build.js:269:23)gyp ERR! stack at ChildProcess.emit (events.js:110:17)gyp ERR! stack at Process.ChildProcess._handle.onexit (child_process.js:10:12)gyp ERR! System Windows_NT 6.1.7601gyp ERR! command "node" "C:\\Program Files (x86)\\nodejs\\node_modules\\npm\\ne_modules\\node-gyp\\bin\\node-gyp.js" "rebuild"gyp ERR! cwd C:\Users\Rao\AppData\Roaming\npm\node_modules\oracledbgyp ERR! node -v v0.12.7gyp ERR! node-gyp -v v2.0.1gyp ERR! not oknpm ERR! Windows_NT 6.1.7601npm ERR! argv "C:\\Program Files (x86)\\nodejs\\\\node.exe" "C:\\Program Filesx86)\\nodejs\\node_modules\\npm\\bin\\npm-cli.js" "install" "oracledb" "-g"npm ERR! node v0.12.7npm ERR! npm v2.11.3npm ERR! code ELIFECYCLEnpm ERR! oracledb@1.5.0 install: `node-gyp rebuild`npm ERR! Exit status 1npm ERR!npm ERR! Failed at the oracledb@1.5.0 install script 'node-gyp rebuild'.npm ERR! This is most likely a problem with the oracledb package,npm ERR! not with npm itself.npm ERR! Tell the author that this fails on your system:npm ERR! node-gyp rebuildnpm ERR! You can get their info via:npm ERR! npm owner ls oracledbnpm ERR! There is likely additional logging output above.npm ERR! Please include the following file with any support request:npm ERR! C:\Users\Rao\npm-debug.log****UPDATE: SOLVED!! *****Issue fixed after doing below steps. Thanks to Pomodory and his links!1) Add a user variable "ToolPath" as "C:\Program Files (x86)\MSBuild\12.0\Bin". I think this is required. No matter what I install this did not get added to PATH automatically.2) Add a user variable "GYP_MSVS_VERSION" as 20133) Add the path "C:\Program Files (x86)\MSBuild\12.0\Bin" to PATH variable.
****** Moderator @"CKPT" edited ********************
I just solved this problem yesterday.
I install vs2015 in my computer, so it can't find the v102 which is belong vs2013.
just run
npm install --msvs_version=2015
here are two links which solve my problem:
http://stackoverflow.com/questions/32556295/npm-install-error-the-build-tools-for-v120-platform-toolset-v120-cannot
https://github.com/nodejs/node-gyp/issues/679
oh!are you use vs2012?
so you should run npm install --msvs_version=2012
just try
Make sure your nodejs and oracle client libraries are the same bitness (64 or 32).
****** Moderator @"CKPT" edited ********************I just solved this problem yesterday.I install vs2015 in my computer, so it can't find the v102 which is belong vs2013.just run npm install --msvs_version=2015here are two links which solve my problem: http://stackoverflow.com/questions/32556295/npm-install-error-the-build-tools-for-v120-platform-toolset-v120-cannot https://github.com/nodejs/node-gyp/issues/679oh!are you use vs2012? so you should run npm install --msvs_version=2012just try
@Pomodory, when you installed VS2015, did you choose "Custom Install" and then select Visual C++" option? I am trying to figure out under what scenario one would need to use --msvs_version=2015 because when I installed VS2015 and selected Visual C++ option, I did not need to use that flag.
Thanks.
I have reinstalled node v4.x 64-bit. But I am getting the below error of msbuild not found. Totally lost on what to install!! Tried visual studio 13, windows build tool, vc redist etc but no luck. In my earlier post the msbuild worked because I have deliberately add the path C:\Windows\Microsoft.NET\Framework64\v4.0.30319
The error I am facing:
D:\dev>npm install oracledb
-
> oracledb@1.5.0 install D:\dev\node_modules\oracledb
> node-gyp rebuild
D:\dev\node_modules\oracledb>if not defined npm_config_node_gyp (node "C:\Progra
m Files\nodejs\node_modules\npm\bin\node-gyp-bin\\..\..\node_modules\node-gyp\bi
n\node-gyp.js" rebuild ) else (node rebuild )
gyp ERR! stack Error: Can't find "msbuild.exe". Do you have Microsoft Visual Stu
dio C++ 2008+ installed?
gyp ERR! stack at findMsbuild (C:\Program Files\nodejs\node_modules\npm\node
_modules\node-gyp\lib\build.js:122:23)
gyp ERR! stack at C:\Program Files\nodejs\node_modules\npm\node_modules\node
-gyp\lib\build.js:104:11
gyp ERR! stack at F (C:\Program Files\nodejs\node_modules\npm\node_modules\w
hich\which.js:78:16)
gyp ERR! stack at E (C:\Program Files\nodejs\node_modules\npm\node_modules\w
hich\which.js:82:29)
gyp ERR! stack at C:\Program Files\nodejs\node_modules\npm\node_modules\whic
h\which.js:93:16
gyp ERR! stack at FSReqWrap.oncomplete (fs.js:82:15)
gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodej
s\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild"
gyp ERR! cwd D:\dev\node_modules\oracledb
gyp ERR! node -v v4.2.4
gyp ERR! node-gyp -v v3.0.3
npm ERR! argv "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\
node_modules\\npm\\bin\\npm-cli.js" "install" "oracledb"
npm ERR! node v4.2.4
npm ERR! npm v2.14.12
Hi,I have reinstalled node v4.x 64-bit. But I am getting the below error of msbuild not found. Totally lost on what to install!! Tried visual studio 13, windows build tool, vc redist etc but no luck. In my earlier post the msbuild worked because I have deliberately add the path C:\Windows\Microsoft.NET\Framework64\v4.0.30319The error I am facing:D:\dev>npm install oracledb-> oracledb@1.5.0 install D:\dev\node_modules\oracledb> node-gyp rebuildD:\dev\node_modules\oracledb>if not defined npm_config_node_gyp (node "C:\Program Files\nodejs\node_modules\npm\bin\node-gyp-bin\\..\..\node_modules\node-gyp\bin\node-gyp.js" rebuild ) else (node rebuild )gyp ERR! build errorgyp ERR! stack Error: Can't find "msbuild.exe". Do you have Microsoft Visual Studio C++ 2008+ installed?gyp ERR! stack at findMsbuild (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\build.js:122:23)gyp ERR! stack at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\build.js:104:11gyp ERR! stack at F (C:\Program Files\nodejs\node_modules\npm\node_modules\which\which.js:78:16)gyp ERR! stack at E (C:\Program Files\nodejs\node_modules\npm\node_modules\which\which.js:82:29)gyp ERR! stack at C:\Program Files\nodejs\node_modules\npm\node_modules\which\which.js:93:16gyp ERR! stack at FSReqWrap.oncomplete (fs.js:82:15)gyp ERR! System Windows_NT 6.1.7601gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild"gyp ERR! cwd D:\dev\node_modules\oracledbgyp ERR! node -v v4.2.4gyp ERR! node-gyp -v v3.0.3gyp ERR! not oknpm ERR! Windows_NT 6.1.7601npm ERR! argv "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\bin\\npm-cli.js" "install" "oracledb"npm ERR! node v4.2.4npm ERR! npm v2.14.12npm ERR! code ELIFECYCLEnpm ERR! oracledb@1.5.0 install: `node-gyp rebuild`npm ERR! Exit status 1
@"Mutyala Rao" have you tried @"Pomodory" suggestion? Try: npm install --msvs_version=2013 oracledb
npm install --msvs_version=2013 oracledb
msvs_version needs to equal the version you currently have installed.
1) Add a user variable "ToolPath" as "C:\Program Files (x86)\MSBuild\12.0\Bin"
Thank you very much for this step by step tutorial! very detailed and well explained !
I am facing issue while installing node oracle driver on my machine. Here are the environment details -Visual Studio - Community version with update 5Python - 2.7.10Node - 4.2.4 (64 bit)Oracle Client - 12.1.0.2.0 (64 bit)System - Windows 7
Here is the log on console -
TRACKER : error TRK0002: Failed to execute command: ""C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\bin\amd64\CL.exe" @C:\Users\shahsv\AppData\Local\Temp\tmp905df070b22245508a85dfe54e2da789.rsp". The parameter is incorrect. [C:\Users\shahsv\Desktop\node app\node_modules\oracledb\build\oracledb.vcxproj]
gyp ERR! build errorgyp ERR! stack Error: C:\Program Files (x86)\MSBuild\12.0\bin\msbuild.exe failed with exit code: 1gyp ERR! stack at ChildProcess.onExit (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\build.js:270:23)gyp ERR! stack at emitTwo (events.js:87:13)gyp ERR! stack at ChildProcess.emit (events.js:172:7)gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:200:12)gyp ERR! System Windows_NT 6.1.7601gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "rebuild"gyp ERR! cwd C:\Users\shahsv\Desktop\node app\node_modules\oracledbgyp ERR! node -v v4.2.4gyp ERR! node-gyp -v v3.0.3gyp ERR! not oknpm ERR! Windows_NT 6.1.7601npm ERR! argv "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\bin\npm-cli.js" "install" "oracledb"npm ERR! node v4.2.4npm ERR! npm v2.14.12npm ERR! code ELIFECYCLE
C:\Program Files (x86)\MSBuild\12.0\bin\msbuild.exe
npm ERR! oracledb@1.5.0 install: node-gyp rebuildnpm ERR! Exit status 1npm ERR!npm ERR! Failed at the oracledb@1.5.0 install script 'node-gyp rebuild'.npm ERR! This is most likely a problem with the oracledb package,npm ERR! not with npm itself.npm ERR! Tell the author that this fails on your system:npm ERR! node-gyp rebuildnpm ERR! You can get their info via:npm ERR! npm owner ls oracledbnpm ERR! There is likely additional logging output above.
node-gyp rebuild
npm ERR! Please include the following file with any support request:npm ERR! C:\Users\shahsv\Desktop\node app\npm-debug.log
Also, here is the debug log -
408 info oracledb@1.5.0 Failed to exec install script409 verbose unlock done using C:\Users\shahsv\AppData\Roaming\npm-cache_locks\oracledb-da25b9573ba09cd6.lock for C:\Users\shahsv\Desktop\node app\node_modules\oracledb410 verbose stack Error: oracledb@1.5.0 install: node-gyp rebuild410 verbose stack Exit status 1410 verbose stack at EventEmitter. (C:\Program Files\nodejs\node_modules\npm\lib\utils\lifecycle.js:214:16)410 verbose stack at emitTwo (events.js:87:13)410 verbose stack at EventEmitter.emit (events.js:172:7)410 verbose stack at ChildProcess. (C:\Program Files\nodejs\node_modules\npm\lib\utils\spawn.js:24:14)410 verbose stack at emitTwo (events.js:87:13)410 verbose stack at ChildProcess.emit (events.js:172:7)410 verbose stack at maybeClose (internal/child_process.js:818:16)410 verbose stack at Process.ChildProcess._handle.onexit (internal/child_process.js:211:5)411 verbose pkgid oracledb@1.5.0412 verbose cwd C:\Users\shahsv\Desktop\node app413 error Windows_NT 6.1.7601414 error argv "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\bin\npm-cli.js" "install" "oracledb"415 error node v4.2.4416 error npm v2.14.12417 error code ELIFECYCLE418 error oracledb@1.5.0 install: node-gyp rebuild418 error Exit status 1419 error Failed at the oracledb@1.5.0 install script 'node-gyp rebuild'.419 error This is most likely a problem with the oracledb package,
Anyone experienced the same problem? Any resolution to it?
As well instead of each time writing "npm install --msvs_version=2015"
you can make system variable GYP_MSVS_VERSION = '2015'.
I've just installed oraclebd on Win'7 x64 with this howto. Thanks a lot @"bchr02" for this!
Before installation VS2015 CE was already installed but without C++ part. So I have got same errors. Then I start VS2015 and choose New project - C++ - Add WindowsSDK 10. After installation has finished and creating GYP_MSVS_VERSION env. variable node-gyp started to compile without errors.
BTW, it said that Microsoft Visual C++ Build Tools 2015 Technical Preview could be used now instead of installing MS VisualStudio. I didn't try it yet.
Got the following compiler error with Visual Studio 2012 and Instant Client: > oracledb@1.8.0 install c:\program files (x86)\microsoft visual studio 11.0\vc\bin\node_modules\oracledb > node-gyp rebuild c:\program files (x86)\microsoft visual studio 11.0\vc\bin\node_modules\oracledb>if not defined npm_config_node_gyp (node "C:\Program Files\nodejs\node_modules\npm\bin\node-gyp-bin\\..\..\node_modules\node-gyp\bin\node-gyp.js" rebuild ) else (node "" rebuild ) Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch. njsOracle.cpp njsPool.cpp njsConnection.cpp njsResultSet.cpp c:\users\yuzhou\.node-gyp\4.4.0\include\node\v8.h(336): error C2988: unrecognizable template declaration/definition (..\src\njs\src\njsOracle.cpp) [c:\program files (x86)\microsoft visual studio 11.0\vc\bin\node_modules\oracledb\build\oracledb.vcxproj] c:\users\yuzhou\.node-gyp\4.4.0\include\node\v8.h(336): error C2059: syntax error : 'using' (..\src\njs\src\njsOracle.cpp) [c:\program files (x86)\microsoft visual studio 11.0\vc\bin\node_modules\oracledb\build\oracledb.vcxproj] c:\users\yuzhou\.node-gyp\4.4.0\include\node\v8.h(469): error C2988: unrecognizable template declaration/definition (..\src\njs\src\njsOracle.cpp) [c:\program files (x86)\microsoft visual studio 11.0\vc\bin\node_modules\oracledb\build\oracledb.vcxproj] c:\users\yuzhou\.node-gyp\4.4.0\include\node\v8.h(469): error C2059: syntax error : 'using' (..\src\njs\src\njsOracle.cpp) [c:\program files (x86)\microsoft visual studio 11.0\vc\bin\node_modules\oracledb\build\oracledb.vcxproj] c:\users\yuzhou\.node-gyp\4.4.0\include\node\v8.h(576): error C2061: syntax error : identifier 'WeakCallbackType' (..\src\njs\src\njsOracle.cpp) [c:\program files (x86)\microsoft visual studio 11.0\vc\bin\node_modules\oracledb\build\oracledb.vcxproj] c:\users\yuzhou\.node-gyp\4.4.0\include\node\v8.h(642) : see reference to class template instantiation 'v8::PersistentBase' being compiled c:\users\yuzhou\.node-gyp\4.4.0\include\node\v8.h(637): error C2253: 'PersistentBase' : pure specifier or abstract override specifier only allowed on virtual function (..\src\njs\src\njsOracle.cpp) [c:\program files (x86)\microsoft visual studio 11.0\vc\bin\node_modules\oracledb\build\oracledb.vcxproj] c:\users\yuzhou\.node-gyp\4.4.0\include\node\v8.h(844): error C2253: 'Global' : pure specifier or abstract override specifier only allowed on virtual function (..\src\njs\src\njsOracle.cpp) [c:\program files (x86)\microsoft visual studio 11.0\vc\bin\node_modules\oracledb\build\oracledb.vcxproj] c:\users\yuzhou\.node-gyp\4.4.0\include\node\v8.h(847) : see reference to class template instantiation 'v8::Global' being compiled c:\users\yuzhou\.node-gyp\4.4.0\include\node\v8.h(852): error C2988: unrecognizable template declaration/definition (..\src\njs\src\njsOracle.cpp) [c:\program files (x86)\microsoft visual studio 11.0\vc\bin\node_modules\oracledb\build\oracledb.vcxproj] c:\users\yuzhou\.node-gyp\4.4.0\include\node\v8.h(852): error C2059: syntax error : 'using' (..\src\njs\src\njsOracle.cpp) [c:\program files (x86)\microsoft visual studio 11.0\vc\bin\node_modules\oracledb\build\oracledb.vcxproj] ...
Post a GitHub issue or post to the OTN forum if you have install issues. Commenting on this doc is not the best place.
Use:
npm i https://github.com/bchr02/node-oracledb#v1.8.0
or to always target the most current release use:
npm i https://github.com/bchr02/node-oracledb#prebuild_support
As well instead of each time writing "npm install --msvs_version=2015"you can make system variable GYP_MSVS_VERSION = '2015'.I've just installed oraclebd on Win'7 x64 with this howto. Thanks a lot @"bchr02" for this!Before installation VS2015 CE was already installed but without C++ part. So I have got same errors. Then I start VS2015 and choose New project - C++ - Add WindowsSDK 10. After installation has finished and creating GYP_MSVS_VERSION env. variable node-gyp started to compile without errors.BTW, it said that Microsoft Visual C++ Build Tools 2015 Technical Preview could be used now instead of installing MS VisualStudio. I didn't try it yet.
This is what worked for me too......I did a default install of Community edition 2015; create project; add Visual C++
npm instasll oracledb on windows :
1.
instantclient-basic-windows.x64-12.1.0.2.0.zip
instantclient-sdk-windows.x64-12.1.0.2.0.zip
OCI_INC_DIR=D:\instantclient_12_1\sdk\include
OCI_LIB_DIR=D:\instantclient_12_1\sdk\lib\msvc
2.
npm install --global windows-build-tools
3.
npm install oracledb
-- oracledb@1.12.2
but when i run the test.
C:\Users\luthy\Desktop\tes>node app.jsC:\Users\luthy\Desktop\tes\node_modules\oracledb\lib\oracledb.js:38 throw err; ^
Error: %1 is not a valid Win32 application.\\?\C:\Users\luthy\Desktop\tes\node_modules\oracledb\build\Release\oracledb.node at Error (native) at Object.Module._extensions..node (module.js:597:18) at Module.load (module.js:487:32) at tryModuleLoad (module.js:446:12) at Function.Module._load (module.js:438:3) at Module.require (module.js:497:17) at require (internal/module.js:20:19) at Object.<anonymous> (C:\Users\luthy\Desktop\tes\node_modules\oracledb\lib\oracledb.js:35:19) at Module._compile (module.js:570:32) at Object.Module._extensions..js (module.js:579:10)
my node and Oracle Instant Client both are 64-bit
Hep me!Help me!
njsOracle.cpp
njsPool.cpp
njsConnection.cpp
njsResultSet.cpp
C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\include\dpiLob.h(34): fatal error C1083: Cannot
clude file: 'oci.h': No such file or directory (compiling source file ..\src\njs\src\njsConnection.cpp) [C:\Use
AppData\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]
njsMessages.cpp
clude file: 'oci.h': No such file or directory (compiling source file ..\src\njs\src\njsResultSet.cpp) [C:\User
ppData\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]
njsIntLob.cpp
clude file: 'oci.h': No such file or directory (compiling source file ..\src\njs\src\njsOracle.cpp) [C:\Users\Y
ata\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]
clude file: 'oci.h': No such file or directory (compiling source file ..\src\njs\src\njsPool.cpp) [C:\Users\Yua
a\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]
dpiEnv.cpp
dpiEnvImpl.cpp
C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\src\dpiEnvImpl.h(30): fatal error C1083: Cannot
clude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiEnv.cpp) [C:\Users\Yuan
\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]
clude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiEnvImpl.cpp) [C:\Users\
Data\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]
dpiException.cpp
dpiExceptionImpl.cpp
dpiConnImpl.cpp
C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\src\dpiConnImpl.h(30): fatal error C1083: Canno
nclude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiConnImpl.cpp) [C:\User
dpiDateTimeArrayImpl.cpp
dpiPoolImpl.cpp
clude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiPoolImpl.cpp) [C:\Users
pData\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]
dpiStmtImpl.cpp
C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\src\dpiUtils.h(30): fatal error C1083: Cannot o
ude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiDateTimeArrayImpl.cpp) [C
Yuan\AppData\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]
dpiUtils.cpp
clude file: 'oci.h': No such file or directory (compiling source file ..\src\njs\src\njsIntLob.cpp) [C:\Users\Y
dpiLob.cpp
C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\include\dpiStmt.h(30): fatal error C1083: Canno
nclude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiStmtImpl.cpp) [C:\User
dpiCommon.cpp
clude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiLob.cpp) [C:\Users\Yuan
win_delay_load_hook.cc
..\src\dpi\src\dpiCommon.cpp(28): fatal error C1083: Cannot open include file: 'oci.h': No such file or directo
sers\Yuan\AppData\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]
ude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiUtils.cpp) [C:\Users\Yuan
gyp ERR! stack Error: `C:\Program Files (x86)\MSBuild\14.0\bin\msbuild.exe` failed with exit code: 1
gyp ERR! stack at ChildProcess.onExit (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\b
76:23)
gyp ERR! stack at emitTwo (events.js:106:13)
gyp ERR! stack at ChildProcess.emit (events.js:194:7)
gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:215:12)
gyp ERR! System Windows_NT 10.0.10240
gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modu
-gyp\\bin\\node-gyp.js" "rebuild"
gyp ERR! cwd C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb
gyp ERR! node -v v7.7.1
gyp ERR! node-gyp -v v3.5.0
npm WARN Error: EPERM: operation not permitted, rmdir 'C:\Users\Yuan\AppData\Roaming\npm\node_modules'
npm WARN { Error: EPERM: operation not permitted, rmdir 'C:\Users\Yuan\AppData\Roaming\npm\node_modules'
npm WARN errno: -4048,
npm WARN code: 'EPERM',
npm WARN syscall: 'rmdir',
npm WARN path: 'C:\\Users\\Yuan\\AppData\\Roaming\\npm\\node_modules' }
npm ERR! Windows_NT 10.0.10240
npm ERR! argv "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\bin\\npm-cli
tall" "-g" "oracledb"
npm ERR! node v7.7.1
npm ERR! npm v4.1.2
npm ERR! oracledb@1.12.2 install: `node-gyp rebuild`
npm ERR! Failed at the oracledb@1.12.2 install script 'node-gyp rebuild'.
npm ERR! Make sure you have the latest version of node.js and npm installed.
npm ERR! If you do, this is most likely a problem with the oracledb package,
npm ERR! You can get information on how to open an issue for this project with:
npm ERR! npm bugs oracledb
npm ERR! Or if that isn't available, you can get their info via:
npm ERR! C:\Users\Yuan\npm-debug.log
C:\Users\Yuan>npm install -g oracledb
> oracledb@1.12.2 install C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb
C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb>if not defined npm_config_node_gyp (node "C:\Program Fi
s\node_modules\npm\bin\node-gyp-bin\\..\..\node_modules\node-gyp\bin\node-gyp.js" rebuild ) else (node "" rebu
gyp WARN install got an error, rolling back install
gyp ERR! configure error
gyp ERR! stack Error: read ECONNRESET
gyp ERR! stack at exports._errnoException (util.js:1029:11)
gyp ERR! stack at TLSWrap.onread (net.js:575:26)
I get the same error:
\\?\\node_modules\oracledb\build\Release\oracledb.
node
at Error (native)
at Object.Module._extensions..node (module.js:597:18)
at Module.load (module.js:487:32)
at tryModuleLoad (module.js:446:12)
at Function.Module._load (module.js:438:3)
at Module.require (module.js:497:17)
at require (internal/module.js:20:19)
at Object.<anonymous> (.\node_modules\oracledb\lib\oracledb.js:35:19)
at Module._compile (module.js:570:32)
at Object.Module._extensions..js (module.js:579:10)
What can I do here??
I follow all steps but when execute node app.js
ORA-12541: TNS:no listener
Help me!
npm instasll oracledb on windows :1.instantclient-basic-windows.x64-12.1.0.2.0.zipinstantclient-sdk-windows.x64-12.1.0.2.0.zipOCI_INC_DIR=D:\instantclient_12_1\sdk\includeOCI_LIB_DIR=D:\instantclient_12_1\sdk\lib\msvc2.npm install --global windows-build-tools3.npm install oracledb-- oracledb@1.12.2but when i run the test.C:\Users\luthy\Desktop\tes>node app.jsC:\Users\luthy\Desktop\tes\node_modules\oracledb\lib\oracledb.js:38 throw err; ^Error: %1 is not a valid Win32 application.\\?\C:\Users\luthy\Desktop\tes\node_modules\oracledb\build\Release\oracledb.node at Error (native) at Object.Module._extensions..node (module.js:597:18) at Module.load (module.js:487:32) at tryModuleLoad (module.js:446:12) at Function.Module._load (module.js:438:3) at Module.require (module.js:497:17) at require (internal/module.js:20:19) at Object.<anonymous> (C:\Users\luthy\Desktop\tes\node_modules\oracledb\lib\oracledb.js:35:19) at Module._compile (module.js:570:32) at Object.Module._extensions..js (module.js:579:10)my node and Oracle Instant Client both are 64-bit
When running your app, make sure D:\instantclient_12_1 is added to PATH env variable.
set PATH=D:\instantclient_12_1;%PATH%
I am able to install and configure everything. But when I run above example I get the error
Is there anything I am missing? Do I need to start oracle server? I dont see any instruction here?
I have tried to install it in my windows 10 box but I have got the following error message.
error MSB4019: The imported project "C:\Microsoft.Cpp.Default.props" was not found
Here the version of the software I using
I am facing the following error.
"C:\Users\Sauravp\AppData\Roaming\npm\node_modules\oracledb\build\binding.sln" (default target) (1) -> "C:\Users\Sauravp\AppData\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj" (default target) (2) -> C:\Users\Sauravp\AppData\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj(20,3): error MSB4019: The imported project "C:\Microsoft.Cpp.Default.props" was not found. Confirm that the path in the <Import> declaration is correct, and that the file exists on disk.
Can anyone guide me on this?
I have moved this in node.js space.