Error: DPI-1050 on Windows 7 with Oracle Client 19c · Issue #1168 · oracle/node-oracledb (original) (raw)

"Error: DPI-1050: Oracle Client library is at version 0.0 but version 11.2 or higher is needed" is received when running on Windows 7 (64bit).
The same setup works correctly on Windows 10 (64bit)

OS: Windows 7 (Version 6.1 Build 7601, Service Pack 1), 64 bit
Node.js: v8.16.2
oracledb: 4.0.1 (problem observed also with older versions)
Oracle Instant Client: 19.3.0.0.0

The Oracle Instant Client 19.3 is copied into 'node_modules\oracledb\build\Release' directory.
(the same problem observed when PATH variable was adjusted to use the Oracle Instant Client directory).
The Visual Studio 2017 redistributables are installed on computer.

Code to reproduce:

const oracledb = require('oracledb');
const POOL_OPTIONS = {
      connectionString: 'doesNotMatter',
      user: 'userName',
      password: 'password'
    };

oracledb.createPool(POOL_OPTIONS, (error, pool) => {
  if(error) {
    console.log(error);
    return;
  }
    
  console.log('Pool created successfully');
  pool.close();
});

Result:

{ Error: DPI-1050: Oracle Client library is at version 0.0 but version 11.2 or higher is needed
    at OracleDb.createPool (c:\Program Files\PM1EncryptionProxy\node_modules\oracledb\lib\oracledb.js:180:8)
    at OracleDb.createPool (c:\Program Files\PM1EncryptionProxy\node_modules\oracledb\lib\util.js:163:19)
    at Object.<anonymous> (c:\Program Files\PM1EncryptionProxy\oracleProblem.js:8:10)
    at Module._compile (module.js:653:30)
    at Object.Module._extensions..js (module.js:664:10)
    at Module.load (module.js:566:32)
    at tryModuleLoad (module.js:506:12)
    at Function.Module._load (module.js:498:3)
    at Function.Module.runMain (module.js:694:10)
    at startup (bootstrap_node.js:204:16) errorNum: 0, offset: 0 } 

Node.js environment:

process.platform // win32
process.version   // v.8.16.2
process.arch       // x64
require('oracledb').versionString  // 4.0.1

Other:
NOTE: The problem does not occur with Oracle Instant Client 18.5.0.0.0

We have tested the problem on several Windows 7 and Windows 10 machines (only 64 bit OS).
The problem is always reproducible on Windows 7 and never on Windows 10.