CLI - Data Bases through ODBC Failed - DB is not defined - oxygen cli

I run the DB package in oxygen ide and everything works fine, but I run through oxygen cli I get this error error: [oxygen] Error occured: db is not defined
Important: At the start of the run I see: warn: [oxygen] Loading module: db. Failed to load - unixodbc binaries not installed

Thanks a lot!


Hello @111,

Please run the following command and post here the output: npm install oxygen-cli -g.


C:\Users\Moti\Documents\RooBi Automation> npm install oxygen-cli -g
C:\Users\Moti\AppData\Roaming\npm\oxygen -> C:\Users\Moti\AppData\Roaming\npm\node_modules\oxygen-cli\lib\cli.js

odbc@1.4.6 install C:\Users\Moti\AppData\Roaming\npm\node_modules\oxygen-cli\node_modules\odbc
node-gyp configure build

C:\Users\Moti\AppData\Roaming\npm\node_modules\oxygen-cli\node_modules\odbc>if not defined npm_config_node_gyp (node “C:\Program Files\nodejs\node_modules\npm\node_modules\npm-lifecycle\node-gyp-bin\…\node_modules\node-gyp\bin\node-gyp.js” configure build ) else (node “C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js” configure build )
gyp ERR! configure error
gyp ERR! stack Error: Can’t find Python executable “python”, you can set the PYTHON env variable.
gyp ERR! stack at PythonFinder.failNoPython (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:484:19)
gyp ERR! stack at PythonFinder. (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:509:16)
gyp ERR! stack at C:\Program Files\nodejs\node_modules\npm\node_modules\graceful-fs\polyfills.js:282:31
gyp ERR! stack at FSReqWrap.oncomplete (fs.js:153:21)
gyp ERR! System Windows_NT 10.0.18362
gyp ERR! command “C:\Program Files\nodejs\node.exe” “C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js” “configure” “build”
gyp ERR! cwd C:\Users\Moti\AppData\Roaming\npm\node_modules\oxygen-cli\node_modules\odbc
gyp ERR! node -v v10.16.3
gyp ERR! node-gyp -v v3.8.0
gyp ERR! not ok
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: odbc@1.4.6 (node_modules\oxygen-cli\node_modules\odbc):
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: odbc@1.4.6 install: node-gyp configure build

  • oxygen-cli@0.47.4
    updated 4 packages in 52.183s

Thank you! @Ben_Teshuva

Apologies for the late reply.
You need to install Windows SDK. And then reinstall oxygen-cli in order to get DB support.
For Windows 10 this is the SDK -

1 Like