Unresolved link on Oracle about node-oracledb HOT 6 CLOSED

You can build with 64 bit client. We haven't tested 32bit but other people report it works.
To help people identify your issue, can you list what you have done and installed, and how you installed it, starting with letting us know which version of Windows you have! Thanks.

from node-oracledb.

I got this working successfully after much gnashing of teeth.

My environment:

• WIndows 7 x64
• Visual Studio 2013 compiler (vc12)
• NodeJS x64 v0.10.35
• Python 2.7

Here's my important notes:

• Follow instructions from README.md, take care of the following:
  • Make sure the NodeJS architecture (x86 vs x64) matches the architecture of the Oracle client installation
  • Do NOT set the PYTHON environment variable (or if you do make sure it works) - if this env var is not pointing at a Python executable then node-gyp is going to fail with process spawn ENEONT errors
• Use NodeJS v0.10.35 - haven't tested on another version
• Find ~./node-gyp/0.10.35/common.gypi - for me this was in: %USERPROFILE%\.node-gyp\0.10.35 (this could be different depending on how you installed node, and if you chose a different node version)
  • Make the following changes below to add msbuild_toolset line to the below Debug section AND to the Release section.

'Debug': {
  'defines': [ 'DEBUG', '_DEBUG' ],
  'cflags': [ '-g', '-O0' ],
  'conditions': [
    ['target_arch=="x64"', {
      'msvs_configuration_platform': 'x64',
      'msbuild_toolset': 'v120_xp'             // added to target VS 2013 compiler
    }],
  ],

Without this change to common.gypi it looks like node-gyp was only targeting the VS2010 compiler (I have both installed on my machine), and I got the following error:

C:\Program Files (x86)\MSBuild\Microsoft.Cpp\v4.0\V120\Microsoft.Cpp.Platform.targets(64,5): error MSB8020: The build tools for Visual Studio 2010 (Platform Toolset = 'v100') cannot be found. To build using the v100 build tools, please install Visual Studio 2010 build tools.  Alternatively, you may upgrade to the current Visual Studio tools by selecting the Project menu or right-click the solution, and then selecting "Upgrade Solution...". [C:\tools\node-oracledb\build\oracledb.vcxproj]

I hope this helps someone...

from node-oracledb.

Thanks for the detail. This piece of the jigsaw will help.

from node-oracledb.

My environment:

• Windows 7 x64
• Visual Studio Community 2013
• NodeJS v0.10.36 x64
• Python 2.7.9 x64

I made the modifications to add the msbuild_toolset as shown above (also modified the platform to be x64, since in my common.gypi it was showing x86 before.

I'll try going to the v0.10.35 version to see if that makes any difference.

from node-oracledb.

OK, it was a bit issue - I had installed x86 when I downgraded to v0.10.36 of Node.

I also had to get around a self-signed certificate error I was seeing as described at http://stackoverflow.com/questions/9626990/receiving-error-error-ssl-error-self-signed-cert-in-chain-while-using-npm

npm config set strict-ssl false

Got everything built without mucking with the common.gypi this time.

from node-oracledb.

Done!
node 10.35 x64.
Oracle client 12.1 x64.
activating the right compiler(amd64).

setting the variables:
set client_dir=C:\jason\generic_workspace\oracleclient\instantclient_12_1

set oci_lib_dir=%client_dir%\sdk\lib\msvc
set oci_inc_dir=%client_dir%\sdk\include

"C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\bin\amd64\vcvars64.bat"

set path=%path%;%client_dir%
set lib=%lib%;%client_dir%;
set libpath=%lib%;%client_dir%;

and running installer:
mpn install oracledb.

And! removing the oracle_server_bin from path variable.

from node-oracledb.