node-oracle icon indicating copy to clipboard operation
node-oracle copied to clipboard

Problems to install node-oracle on windows8 64bits

Open igormaffei opened this issue 12 years ago • 12 comments

[email protected] install C:\Igor\Node.JS\teste\node_modules\oracle node-gyp rebuild

I have many issues to install windows 8 64bits node v0.10.12. Can you help me please?

C:\Igor\Node.JS\teste\node_modules\oracle>node "C:\Program Files (x86)\nodejs\node_modules\npm\bin\node-gyp-bin....\node_modules\node-gyp\bin\node-gyp.js" rebuild Compilando os projetos desta solu‡Æo um de cada vez. Para habilitar a compila‡Æo paralela, adicione a op‡Æo "/m". executeBaton.cpp outParam.cpp connection.cpp oracle_bindings.cpp C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\include\xlocale(336): warning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc (..\src\outParam.cpp) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\include\xlocale(336): warning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc (..\src\oracle_bindings.cpp) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\include\xlocale(336): warning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc (..\src\executeBaton.cpp) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\include\xlocale(336): warning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc (..\src\connection.cpp) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] ..\src\outParam.cpp(23): warning C4244: '=' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] ..\src\outParam.cpp(27): warning C4244: '=' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] ..\src\outParam.cpp(34): warning C4244: '=' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] ..\src\outParam.cpp(42): warning C4244: '=' : conversion from 'double' to 'float', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] ..\src\outParam.cpp(42): warning C4244: '=' : conversion from 'int' to 'float', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] ..\src\oracle_bindings.cpp(67): warning C4244: '=' : conversion from 'double' to 'uint32_t', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] ..\src\executeBaton.cpp(61): warning C4244: 'initializing' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] ..\src\executeBaton.cpp(62): warning C4244: 'initializing' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] ..\src\executeBaton.cpp(63): warning C4244: 'initializing' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] ..\src\executeBaton.cpp(64): warning C4244: 'initializing' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] ..\src\executeBaton.cpp(65): warning C4244: 'initializing' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] ..\src\executeBaton.cpp(66): warning C4244: 'initializing' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] ..\src\connection.cpp(596): warning C4267: 'argument' : conversion from 'size_t' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\include\xlocnum(155): warning C4506: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New(v8::Handle<T>)' [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] with T=v8::Object C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\include\xlocnum(155): warning C4506: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New(v8::Handle<T>)' [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] with T=v8::FunctionTemplate C:\Users\IMaia.node-gyp\0.10.12\deps\v8\include\v8.h(218): warning C4506: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New(v8::Handle<T>)' [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] with T=v8::Object C:\Users\IMaia.node-gyp\0.10.12\deps\v8\include\v8.h(218): warning C4506: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New(v8::Handle<T>)' [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] with T=v8::FunctionTemplate C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\include\xmemory0(605): warning C4506: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New(v8::Handle<T>)' [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] with T=v8::Object C:\Users\IMaia.node-gyp\0.10.12\deps\v8\include\v8.h(218): warning C4506: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New(v8::Handle<T>)' [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] with T=v8::Object C:\Users\IMaia.node-gyp\0.10.12\deps\v8\include\v8.h(218): warning C4506: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New(v8::Handle<T>)' [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] with T=v8::FunctionTemplate Creating library C:\Igor\Node.JS\teste\node_modules\oracle\build\Release\oracle_bindings.lib and object C:\Igor\Node.JS\teste\node_modules\oracle\build\Release\oracle_bindings.exp executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Clob::~Clob(void)" (??1Clob@occi@oracle@@QEAA@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Clob::Clob(void)" (??0Clob@occi@oracle@@QEAA@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Blob::~Blob(void)" (??1Blob@occi@oracle@@QEAA@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Blob::Blob(void)" (??0Blob@occi@oracle@@QEAA@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Date::~Date(void)" (??1Date@occi@oracle@@QEAA@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Date::Date(void)" (??0Date@occi@oracle@@QEAA@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Date::Date(class oracle::occi::Environment const _,int,unsigned int,unsigned int,unsigned int,unsigned int,unsigned int)" (??0Date@occi@oracle@@QEAA@PEBVEnvironment@12@HIIIII@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Timestamp::~Timestamp(void)" (??1Timestamp@occi@oracle@@QEAA@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Timestamp::Timestamp(void)" (??0Timestamp@occi@oracle@@QEAA@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Number::~Number(void)" (??1Number@occi@oracle@@QEAA@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Number::Number(void)" (??0Number@occi@oracle@@QEAA@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Number::Number(double)" (??0Number@occi@oracle@@QEAA@N@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] outParam.obj : error LNK2001: unresolved external symbol "public: class oracle::occi::Number & __cdecl oracle::occi::Number::operator=(class oracle::occi::Number const &)" (??4Number@occi@oracle@@QEAAAEAV012@AEBV012@@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] outParam.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Number::Number(int)" (??0Number@occi@oracle@@QEAA@H@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Clob::closeStream(class oracle::occi::Stream *)" (?closeStream@Clob@occi@oracle@@QEAAXPEAVStream@23@@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: class oracle::occi::Stream * __cdecl oracle::occi::Clob::getStream(unsigned int,unsigned int)" (?getStream@Clob@occi@oracle@@QEAAPEAVStream@23@II@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Clob::close(void)" (?close@Clob@occi@oracle@@QEAAXXZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Clob::open(enum oracle::occi::LobOpenMode)" (?open@Clob@occi@oracle@@QEAAXW4LobOpenMode@23@@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: class oracle::occi::Clob & __cdecl oracle::occi::Clob::operator=(class oracle::occi::Clob const &)" (??4Clob@occi@oracle@@QEAAAEAV012@AEBV012@@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Clob::setCharSetForm(enum oracle::occi::CharSetForm)" (?setCharSetForm@Clob@occi@oracle@@QEAAXW4CharSetForm@23@@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: unsigned int __cdecl oracle::occi::Clob::length(void)const " (?length@Clob@occi@oracle@@QEBAIXZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Blob::closeStream(class oracle::occi::Stream *)" (?closeStream@Blob@occi@oracle@@QEAAXPEAVStream@23@@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: class oracle::occi::Stream * __cdecl oracle::occi::Blob::getStream(unsigned int,unsigned int)" (?getStream@Blob@occi@oracle@@QEAAPEAVStream@23@II@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Blob::close(void)" (?close@Blob@occi@oracle@@QEAAXXZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Blob::open(enum oracle::occi::LobOpenMode)" (?open@Blob@occi@oracle@@QEAAXW4LobOpenMode@23@@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: class oracle::occi::Blob & __cdecl oracle::occi::Blob::operator=(class oracle::occi::Blob const &)" (??4Blob@occi@oracle@@QEAAAEAV012@AEBV012@@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: unsigned int __cdecl oracle::occi::Blob::length(void)const " (?length@Blob@occi@oracle@@QEBAIXZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: class oracle::occi::Date & __cdecl oracle::occi::Date::operator=(class oracle::occi::Date const &)" (??4Date@occi@oracle@@QEAAAEAV012@AEBV012@@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Date::getDate(int &,unsigned int &,unsigned int &,unsigned int &,unsigned int &,unsigned int &)const " (?getDate@Date@occi@oracle@@QEBAXAEAHAEAI1111@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: class oracle::occi::Timestamp & __cdecl oracle::occi::Timestamp::operator=(class oracle::occi::Timestamp const &)" (??4Timestamp@occi@oracle@@QEAAAEAV012@AEBV012@@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Timestamp::getDate(int &,unsigned int &,unsigned int &)const " (?getDate@Timestamp@occi@oracle@@QEBAXAEAHAEAI1@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Timestamp::getTime(unsigned int &,unsigned int &,unsigned int &,unsigned int &)const " (?getTime@Timestamp@occi@oracle@@QEBAXAEAI000@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Number::operator double(void)const " (??BNumber@occi@oracle@@QEBANXZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::MetaData::~MetaData(void)" (??1MetaData@occi@oracle@@QEAA@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: class std::basic_string<char,struct std::char_traits,class std::allocator > __cdecl oracle::occi::MetaData::getString(enum oracle::occi::MetaData::AttrId)const " (?getString@MetaData@occi@oracle@@QEBA?AV?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@W4AttrId@123@@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: int __cdecl oracle::occi::MetaData::getInt(enum oracle::occi::MetaData::AttrId)const " (?getInt@MetaData@occi@oracle@@QEBAHW4AttrId@123@@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] connection.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::MetaData::MetaData(class oracle::occi::MetaData const &)" (??0MetaData@occi@oracle@@QEAA@AEBV012@@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] oracle_bindings.obj : error LNK2001: unresolved external symbol "public: static void __cdecl oracle::occi::Environment::terminateEnvironment(class oracle::occi::Environment *)" (?terminateEnvironment@Environment@occi@oracle@@SAXPEAV123@@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] oracle_bindings.obj : error LNK2001: unresolved external symbol "public: static class oracle::occi::Environment * __cdecl oracle::occi::Environment::createEnvironment(enum oracle::occi::Environment::Mode,void *,void * (_cdecl)(void _,unsigned __int64),void * (_cdecl)(void _,void *,unsigned __int64),void (_cdecl)(void *,void *))" (?createEnvironment@Environment@occi@oracle@@SAPEAV123@W4Mode@123@PEAXP6APEAX1_K@ZP6APEAX112@ZP6AX11@Z@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj] C:\Igor\Node.JS\teste\node_modules\oracle\build\Release\oracle_bindings.node : fatal error LNK1120: 39 unresolved externals [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.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_mo dules\npm\node_modules\node-gyp\lib\build.js:267:23) gyp ERR! stack at ChildProcess.EventEmitter.emit (events.js:98:17) gyp ERR! stack at Process.ChildProcess._handle.onexit (child_process.js:789: 12) gyp ERR! System Windows_NT 6.2.9200 gyp ERR! command "node" "C:\Program Files (x86)\nodejs\node_modules\npm\nod e_modules\node-gyp\bin\node-gyp.js" "rebuild" gyp ERR! cwd C:\Igor\Node.JS\teste\node_modules\oracle gyp ERR! node -v v0.10.12 gyp ERR! node-gyp -v v0.10.0 gyp ERR! not ok npm ERR! weird error 1 npm ERR! not ok code 0

C:\Igor\Node.JS\teste>npm install oracle >>erro.txt npm http GET https://registry.npmjs.org/oracle npm http 304 https://registry.npmjs.org/oracle 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_mo dules\npm\node_modules\node-gyp\lib\build.js:267:23) gyp ERR! stack at ChildProcess.EventEmitter.emit (events.js:98:17) gyp ERR! stack at Process.ChildProcess._handle.onexit (child_process.js:789: 12) gyp ERR! System Windows_NT 6.2.9200 gyp ERR! command "node" "C:\Program Files (x86)\nodejs\node_modules\npm\nod e_modules\node-gyp\bin\node-gyp.js" "rebuild" gyp ERR! cwd C:\Igor\Node.JS\teste\node_modules\oracle gyp ERR! node -v v0.10.12 gyp ERR! node-gyp -v v0.10.0 gyp ERR! not ok npm ERR! weird error 1 npm ERR! not ok code 0

igormaffei avatar Jun 21 '13 00:06 igormaffei

I had the same issue with Windows 7, trying to use the 64bit Oracle client. It seems on Windows only 32bit is supported.

To compile on 64 bit, use:

npm install --arch=ia32

sonata82 avatar Nov 26 '13 10:11 sonata82

I'm running into the exact same issue.

System: Windows Server 2008 x64 Oracle Client: 12_1 x64 Nodejs: x64

I tried npm install --arch=ia32 oracle but no luck. Was anybody able to fix this issue ?

kurteknikk avatar Mar 12 '14 09:03 kurteknikk

I got it to compile on Windows 7 64Bit with Visual Studio Express 2010 plus Windows 7.1 SDK using instantclient 12.1 (64Bit!). So 64Bit should work. Quite a hassle though

kontrafiktion avatar Mar 12 '14 10:03 kontrafiktion

I just tried the following (from scratch, it's a virtual machine) on a Windows Server 2008 x64

  • Install Windows 7.1 SDK
  • Install Visual Studio C++ 2010 express edition
  • Install nodejs x64
  • Extract oracle instant client x64
  • npm install oracle -- Results in error MSB8007
  • npm install --arch=ia32 oracle -- Seems to go further with some warnings, but still fails with 39 unresolved externals

Any idea what else can I try ? (to solve these 'unresolved externals')

kurteknikk avatar Mar 12 '14 12:03 kurteknikk

Are you using the SDK prompt? In your start menu should be an entry with a SDK 7.1 prompt

I did not compile with --arch

kontrafiktion avatar Mar 12 '14 12:03 kontrafiktion

And perhaps you could post your %PATH% and %OCI_*_DIR%

kontrafiktion avatar Mar 12 '14 12:03 kontrafiktion

No I was running it from the normal cmd. I opened the SDK prompt and first thing is see is: "The x64 compilers are not currently installed."

I ran npm install oracle, it starts by running node-gyp rebuild and it's like running for over 10minutes, 100% cpu but I don't see anything happening (pc is still responding, it's just that process that's very busy).

I also ran your pre-install-check.js and it reports everything ok.

These are the system variables that I setup:

OCI_INCLUDE_DIR c:\apps\instantclient_12_1\sdk\include OCI_LIB_DIR c:\apps\instantclient_12_1\sdk\lib\msvc\vc10 OCI_VERSION 12

And this is the PATH:

PATH=;C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE;C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\Tools;;;;C:\Windows\system32;C :\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C :\Program Files\Microsoft Windows Performance Toolkit;C:\Program Files\nodejs; c:\apps\instantclient_12_1\vc10;c:\apps\instantclient_12_1;C:\Users\Administrato r\AppData\Roaming\npm

P.S after i open the windows sdk prompt I cd into my directory (I don't know if maybe that's effecting something)

c:\apps\myApp>npm install oracle

[email protected] install c:\apps\myApp\node_modules\oracle node-gyp rebuild

(Sorry for any stupid questions, but i rarely use Windows.)

kurteknikk avatar Mar 12 '14 13:03 kurteknikk

Compilation should only be done from either the SDK prompt or one of the VS command prompts. If you don't have any 64 bit compilers installed, then compile for 32 bit.

But choose one or the other: if you compile 32 bit, then NodeJS and the Oracle instance client have to be 32bit too!

sonata82 avatar Mar 12 '14 13:03 sonata82

@sonata82 thanks for making things clear, i'm currently downloading 'Microsoft Visual C++ 2010 Service Pack 1 Compiler Update' which should have the x64 compilers and then hopefully I can compile in 64bit.

(Small question aside) The fact that compilation should only be done from the SDK prompt, does it apply only for this module or for all node modules in windows ?

kurteknikk avatar Mar 12 '14 13:03 kurteknikk

It applies to all compilations done using VS :-)

sonata82 avatar Mar 12 '14 13:03 sonata82

Downloaded, installed and tried one more time. I have the feeling that i'm getting closer but it still complains: "C1083: Cannot open include file: 'ammintrin.h':" Quick search suggests there might have been something broken with some windows update but i still need to look further.

This is the log (maybe you can see something which i'm not seeing)

c:\apps\myApp>npm install oracle

[email protected] install c:\apps\myApp\node_modules\oracle node-gyp rebuild

c:\apps\myApp\node_modules\oracle>node "C:\Program Files\nodejs\node_module s\npm\bin\node-gyp-bin....\node_modules\node-gyp\bin\node-gyp.js" rebuild reader.cpp c:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\xlocale(323): wa rning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcx proj] c:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\intrin.h(26): fa tal error C1083: Cannot open include file: 'ammintrin.h': No such file or direc tory [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcxproj] executeBaton.cpp c:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\xlocale(323): wa rning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcx proj] c:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\intrin.h(26): fa tal error C1083: Cannot open include file: 'ammintrin.h': No such file or direc tory [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcxproj] outParam.cpp c:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\xlocale(323): wa rning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcx proj] c:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\intrin.h(26): fa tal error C1083: Cannot open include file: 'ammintrin.h': No such file or direc tory [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcxproj] connection.cpp c:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\xlocale(323): wa rning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcx proj] c:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\intrin.h(26): fa tal error C1083: Cannot open include file: 'ammintrin.h': No such file or direc tory [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcxproj] oracle_bindings.cpp c:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\xlocale(323): wa rning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcx proj] c:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\intrin.h(26): fa tal error C1083: Cannot open include file: 'ammintrin.h': No such file or direc tory [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcxproj] statement.cpp c:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\xlocale(323): wa rning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcx proj] c:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\intrin.h(26): fa tal error C1083: Cannot open include file: 'ammintrin.h': No such file or direc tory [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcxproj] gyp ERR! build error gyp ERR! stack Error: msbuild failed with exit code: 1 gyp ERR! stack at ChildProcess.onExit (C:\Program Files\nodejs\node_modules
npm\node_modules\node-gyp\lib\build.js:267:23) gyp ERR! stack at ChildProcess.EventEmitter.emit (events.js:98:17) gyp ERR! stack at Process.ChildProcess._handle.onexit (child_process.js:797: 12) gyp ERR! System Windows_NT 6.1.7601 gyp ERR! command "node" "C:\Program Files\nodejs\node_modules\npm\node_modu les\node-gyp\bin\node-gyp.js" "rebuild" gyp ERR! cwd c:\apps\myApp\node_modules\oracle gyp ERR! node -v v0.10.26 gyp ERR! node-gyp -v v0.12.2 gyp ERR! not ok npm ERR! [email protected] install: node-gyp rebuild npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script. npm ERR! This is most likely a problem with the oracle 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 oracle npm ERR! There is likely additional logging output above.

npm ERR! System Windows_NT 6.1.7601 npm ERR! command "C:\Program Files\nodejs\node.exe" "C:\Program Files\nod ejs\node_modules\npm\bin\npm-cli.js" "install" "oracle" npm ERR! cwd c:\apps\myApp npm ERR! node -v v0.10.26 npm ERR! npm -v 1.4.3 npm ERR! code ELIFECYCLE npm ERR! npm ERR! Additional logging details can be found in: npm ERR! c:\apps\myApp\npm-debug.log npm ERR! not ok code 0

kurteknikk avatar Mar 12 '14 13:03 kurteknikk

It was an issue from Microsoft which they refuse to fix. Anyway a re-install of Visual Studio 2010 seems to fix the problem.

So my issue for now is solved, thanks for all your help guys.

This is the log I have now, I still have warnings, but at least it's installed now.

c:\apps\myApp>npm install oracle

[email protected] install c:\apps\myApp\node_modules\oracle node-gyp rebuild

c:\apps\myApp\node_modules\oracle>node "C:\Program Files\nodejs\node_module s\npm\bin\node-gyp-bin....\node_modules\node-gyp\bin\node-gyp.js" rebuild reader.cpp C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\xlocale(323): wa rning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcx proj] ..\src\reader.cpp(57): warning C4244: 'initializing' : conversion from 'double' to 'int', possible loss of data [c:\apps\myApp\node_modules\oracle\build
oracle_bindings.vcxproj] C:\Users\Administrator.node-gyp\0.10.26\deps\v8\include\v8.h(184): warning C45 06: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New (v8::Handle<T>)' [c:\apps\myApp\node_modules\oracle\build\oracle_bindings. vcxproj] with [ T=v8::Object ] C:\Users\Administrator.node-gyp\0.10.26\deps\v8\include\v8.h(184): warning C45 06: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New (v8::Handle<T>)' [c:\apps\myApp\node_modules\oracle\build\oracle_bindings. vcxproj] with [ T=v8::FunctionTemplate ] executeBaton.cpp C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\xlocale(323): wa rning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcx proj] ..\src\executeBaton.cpp(91): warning C4244: 'initializing' : conversion from 'd ouble' to 'int', possible loss of data [c:\apps\myApp\node_modules\oracle
build\oracle_bindings.vcxproj] ..\src\executeBaton.cpp(92): warning C4244: 'initializing' : conversion from 'd ouble' to 'int', possible loss of data [c:\apps\myApp\node_modules\oracle
build\oracle_bindings.vcxproj] ..\src\executeBaton.cpp(93): warning C4244: 'initializing' : conversion from 'd ouble' to 'int', possible loss of data [c:\apps\myApp\node_modules\oracle
build\oracle_bindings.vcxproj] ..\src\executeBaton.cpp(94): warning C4244: 'initializing' : conversion from 'd ouble' to 'int', possible loss of data [c:\apps\myApp\node_modules\oracle
build\oracle_bindings.vcxproj] ..\src\executeBaton.cpp(95): warning C4244: 'initializing' : conversion from 'd ouble' to 'int', possible loss of data [c:\apps\myApp\node_modules\oracle
build\oracle_bindings.vcxproj] ..\src\executeBaton.cpp(96): warning C4244: 'initializing' : conversion from 'd ouble' to 'int', possible loss of data [c:\apps\myApp\node_modules\oracle
build\oracle_bindings.vcxproj] ..\src\executeBaton.cpp(97): warning C4244: 'initializing' : conversion from 'd ouble' to 'int', possible loss of data [c:\apps\myApp\node_modules\oracle
build\oracle_bindings.vcxproj] C:\Users\Administrator.node-gyp\0.10.26\deps\v8\include\v8.h(184): warning C45 06: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New (v8::Handle<T>)' [c:\apps\myApp\node_modules\oracle\build\oracle_bindings. vcxproj] with [ T=v8::Object ] outParam.cpp C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\xlocale(323): wa rning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcx proj] ..\src\outParam.cpp(30): warning C4244: '=' : conversion from 'double' to 'int' , possible loss of data [c:\apps\myApp\node_modules\oracle\build\oracle_bi ndings.vcxproj] ..\src\outParam.cpp(37): warning C4244: '=' : conversion from 'double' to 'int' , possible loss of data [c:\apps\myApp\node_modules\oracle\build\oracle_bi ndings.vcxproj] ..\src\outParam.cpp(44): warning C4244: '=' : conversion from 'double' to 'int' , possible loss of data [c:\apps\myApp\node_modules\oracle\build\oracle_bi ndings.vcxproj] ..\src\outParam.cpp(52): warning C4244: '=' : conversion from 'double' to 'floa t', possible loss of data [c:\apps\myApp\node_modules\oracle\build\oracle_ bindings.vcxproj] ..\src\outParam.cpp(52): warning C4244: '=' : conversion from 'int' to 'float', possible loss of data [c:\apps\myApp\node_modules\oracle\build\oracle_bin dings.vcxproj] C:\Users\Administrator.node-gyp\0.10.26\deps\v8\include\v8.h(184): warning C45 06: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New (v8::Handle<T>)' [c:\apps\myApp\node_modules\oracle\build\oracle_bindings. vcxproj] with [ T=v8::Object ] C:\Users\Administrator.node-gyp\0.10.26\deps\v8\include\v8.h(184): warning C45 06: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New (v8::Handle<T>)' [c:\apps\myApp\node_modules\oracle\build\oracle_bindings. vcxproj] with [ T=v8::FunctionTemplate ] connection.cpp C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\xlocale(323): wa rning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcx proj] ..\src\connection.cpp(182): warning C4244: 'initializing' : conversion from 'do uble' to 'int', possible loss of data [c:\apps\myApp\node_modules\oracle\b uild\oracle_bindings.vcxproj] ..\src\connection.cpp(192): warning C4101: 'ex' : unreferenced local variable [ c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcxproj] ..\src\connection.cpp(588): warning C4244: '=' : conversion from 'double' to 'u nsigned int', possible loss of data [c:\apps\myApp\node_modules\oracle\bui ld\oracle_bindings.vcxproj] ..\src\connection.cpp(665): warning C4267: 'argument' : conversion from 'size_t ' to 'unsigned int', possible loss of data [c:\apps\myApp\node_modules\ora cle\build\oracle_bindings.vcxproj] ..\src\connection.cpp(670): warning C4267: 'argument' : conversion from 'size_t ' to 'unsigned int', possible loss of data [c:\apps\myApp\node_modules\ora cle\build\oracle_bindings.vcxproj] ..\src\connection.cpp(717): warning C4267: 'argument' : conversion from 'size_t ' to 'int', possible loss of data [c:\apps\myApp\node_modules\oracle\build \oracle_bindings.vcxproj] ..\src\connection.cpp(799): warning C4267: 'argument' : conversion from 'size_t ' to 'unsigned int', possible loss of data [c:\apps\myApp\node_modules\ora cle\build\oracle_bindings.vcxproj] ..\src\connection.cpp(804): warning C4267: 'argument' : conversion from 'size_t ' to 'unsigned int', possible loss of data [c:\apps\myApp\node_modules\ora cle\build\oracle_bindings.vcxproj] C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\xmemory(212): wa rning C4506: no definition for inline function 'v8::Persistent<T> v8::Persisten t<T>::New(v8::Handle<T>)' [c:\apps\myApp\node_modules\oracle\build\oracle_ bindings.vcxproj] with [ T=v8::Object ] C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\xmemory(212): wa rning C4506: no definition for inline function 'v8::Persistent<T> v8::Persisten t<T>::New(v8::Handle<T>)' [c:\apps\myApp\node_modules\oracle\build\oracle_ bindings.vcxproj] with [ T=v8::FunctionTemplate ] oracle_bindings.cpp C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\xlocale(323): wa rning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcx proj] ..\src\oracle_bindings.cpp(103): warning C4244: '=' : conversion from 'double' to 'uint32_t', possible loss of data [c:\apps\myApp\node_modules\oracle\bu ild\oracle_bindings.vcxproj] ..\src\oracle_bindings.cpp(168): warning C4244: '=' : conversion from 'double' to 'uint32_t', possible loss of data [c:\apps\myApp\node_modules\oracle\bu ild\oracle_bindings.vcxproj] C:\Users\Administrator.node-gyp\0.10.26\deps\v8\include\v8.h(184): warning C45 06: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New (v8::Handle<T>)' [c:\apps\myApp\node_modules\oracle\build\oracle_bindings. vcxproj] with [ T=v8::Object ] C:\Users\Administrator.node-gyp\0.10.26\deps\v8\include\v8.h(184): warning C45 06: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New (v8::Handle<T>)' [c:\apps\myApp\node_modules\oracle\build\oracle_bindings. vcxproj] with [ T=v8::FunctionTemplate ] statement.cpp C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\xlocale(323): wa rning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc [c:\apps\myApp\node_modules\oracle\build\oracle_bindings.vcx proj] C:\Users\Administrator.node-gyp\0.10.26\deps\v8\include\v8.h(184): warning C45 06: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New (v8::Handle<T>)' [c:\apps\myApp\node_modules\oracle\build\oracle_bindings. vcxproj] with [ T=v8::Object ] C:\Users\Administrator.node-gyp\0.10.26\deps\v8\include\v8.h(184): warning C45 06: no definition for inline function 'v8::Persistent<T> v8::Persistent<T>::New (v8::Handle<T>)' [c:\apps\myApp\node_modules\oracle\build\oracle_bindings. vcxproj] with [ T=v8::FunctionTemplate ] Creating library c:\apps\myApp\node_modules\oracle\build\Release\orac le_bindings.lib and object c:\apps\myApp\node_modules\oracle\build\Relea se\oracle_bindings.exp Generating code Finished generating code oracle_bindings.vcxproj -> c:\apps\myApp\node_modules\oracle\build\Relea se\oracle_bindings.node [email protected] node_modules\oracle

kurteknikk avatar Mar 12 '14 14:03 kurteknikk