search

ibmdb / node-ibm_db

IBM DB2 and IBM Informix bindings for node
MIT License
188 stars 151 forks source link

Error: '[node-ibm_db] Error in ODBC::GetColumnValue' #871

Closed techabhay366 closed 2 years ago

techabhay366 commented 2 years ago

OS -: Windows 10 Db2Level -: DB21085I This instance or install (instance name, where applicable: "*") uses "64" bits and DB2 code release "SQL11014" with level identifier "0205010F". Informational tokens are "DB2 v11.1.4050.860", "special_39510", "DYN1911120100WIN64_39510", and Fix Pack "5". Product is installed at "C:\XYZ\Redox\node_modules\ibm_db\installer\clidriver" with DB2 Copy Name "IBM Data Server Driver For ODBC and CLI".

node.js version v17.2.0

ibm_db version 2.8.1

I am using following to create open a connection with IBM Db2 database and run a simple Query.

var ibmdb = require('ibm_db'); var connStr = "DRIVER={IBM DB2 ODBC DRIVER - DB2COPY1};HOSTNAME=XXXXXDATABASE=XXXX;PORT=XXXX;PROTOCOL=TCPIP;UID=xxxxxxxxxx;PWD=xxxxxxxxx"; var conn = ibmdb.open(connStr, function (err,conn) { if (err) return console.log(err); else console.log(conn); conn.query('select 1 from sysibm.sysdummy1 ',function (err, data) { if (err) console.log(err); else { console.log(data) } conn.close(function () { console.log('done'); }); }); });

When I run this Query i get following error -: Database { odbc: ODBC {}, queue: SimpleQueue { fifo: [], executing: false }, fetchMode: null, connected: true, connectTimeout: null, systemNaming: undefined, codeSet: null, mode: null, pool: null, conn: ODBCConnection { systemNaming: false, connectTimeout: 30, connected: true } } [Error: [Microsoft][ODBC Driver Manager] Invalid descriptor index] { error: '[node-ibm_db] Error in ODBC::GetColumnValue', sqlcode: 0, state: '07009' } done

I am connecting to remote database sitting on z/OS and I have proper license to connect . I tried using the same license for the Db2 extension and I am able to connect and rum my queries from there.

I looked at some issues raised earlier with similar error but could not fix the issue. May I know the reason for this error " Error in ODBC::GetColumnValue', "

bimalkjha commented 2 years ago

@techabhay366 In the error output, we can see [Microsoft][ODBC Driver Manager]. It is the root cause of problem. Probably, your installation is not correct. First remove DRIVER={IBM DB2 ODBC DRIVER - DB2COPY1}; from your connection string and return the test. If issue persists, then cd to C:\XYZ\Redox\node_modules\ibm_db and run npm install. On successful installation, rerun the test program. If still issue exist, share the complete output of npm install command here. Thanks.

techabhay366 commented 2 years ago

Hi @bimalkjha , I tried as you suggested -:

1) Removed DRIVER={IBM DB2 ODBC DRIVER - DB2COPY1}; Reran the script and got following error -: [Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]

2) Then I did npm install , log -: 

PS C:\XYZ\Redox>  cd .\node_modules\ibm_db\
PS C:\XYZ\Redox\node_modules\ibm_db> npm install

> ibm_db@2.8.1 install
> node installer/driverInstall.js

platform = win32, arch = x64, node.js version = v17.2.0
IBM_DB_HOME environment variable have already set to -> C:\XYZ\Redox\node_modules\ibm_db\installer\clidriver

Downloading of clidriver skipped - build is in progress...

Building the projects in this solution one at a time. To enable parallel build, please add the "-m" switch.
  odbc.cpp
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(216,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(228,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(705,73): warning C4311: 'type cast': pointer truncation from 'SQLHSTMT' to 'long' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(705,73): warning C4302: 'type cast': truncation from 'SQLHSTMT' to 'long' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(706,33): warning C4311: 'type cast': pointer truncation from 'SQLHSTMT' to 'long' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(706,33): warning C4302: 'type cast': truncation from 'SQLHSTMT' to 'long' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(1413,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
  odbc_connection.cpp
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(310,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(534,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(909,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1094,60): warning C4312: 'type cast': conversion from 'int32_t' to 'SQLPOINTER' of greater size [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1148,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1178,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1341,55): warning C4312: 'type cast': conversion from 'int32_t' to 'SQLPOINTER' of greater size [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1714,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1896,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(2100,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
  odbc_statement.cpp
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(246,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(422,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1724): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(573,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(778,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(949,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(980,85): warning C4312: 'type cast': conversion from 'int32_t' to 'SQLPOINTER' of greater size [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]  
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(1047,91): warning C4312: 'type cast': conversion from 'int32_t' to 'SQLPOINTER' of greater size [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj] 
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(1121,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(1244,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
  odbc_result.cpp
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_result.cpp(287,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_result.cpp(312,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_result.cpp(598,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
  strptime.c
  win_delay_load_hook.cc
     Creating library C:\XYZ\Redox\node_modules\ibm_db\build\Release\odbc_bindings.lib and object C:\XYZ\Redox\node_modules\ibm_db\build\Release\odbc_bindings.exp
  Generating code
  Previous IPDB not found, fall back to full compilation.
  All 559 functions were compiled because no usable IPDB/IOBJ from previous compilation was found.
  Finished generating code
  odbc_bindings.vcxproj -> C:\XYZ\Redox\node_modules\ibm_db\build\Release\\odbc_bindings.node

Kernel additional dependencies removed successfully!

Building the projects in this solution one at a time. To enable parallel build, please add the "-m" switch.
  odbc.cpp
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(216,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(228,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(705,73): warning C4311: 'type cast': pointer truncation from 'SQLHSTMT' to 'long' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(705,73): warning C4302: 'type cast': truncation from 'SQLHSTMT' to 'long' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(706,33): warning C4311: 'type cast': pointer truncation from 'SQLHSTMT' to 'long' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(706,33): warning C4302: 'type cast': truncation from 'SQLHSTMT' to 'long' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(1413,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
  odbc_connection.cpp
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(310,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(534,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(909,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1094,60): warning C4312: 'type cast': conversion from 'int32_t' to 'SQLPOINTER' of greater size [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1148,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1178,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1341,55): warning C4312: 'type cast': conversion from 'int32_t' to 'SQLPOINTER' of greater size [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1714,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1896,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(2100,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
  odbc_statement.cpp
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(246,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(422,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1724): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(573,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(778,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(949,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(980,85): warning C4312: 'type cast': conversion from 'int32_t' to 'SQLPOINTER' of greater size [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]  
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(1047,91): warning C4312: 'type cast': conversion from 'int32_t' to 'SQLPOINTER' of greater size [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj] 
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(1121,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(1244,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
  odbc_result.cpp
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_result.cpp(287,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_result.cpp(312,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_result.cpp(598,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
  strptime.c
  win_delay_load_hook.cc
     Creating library C:\XYZ\Redox\node_modules\ibm_db\build\Release\odbc_bindings.lib and object C:\XYZ\Redox\node_modules\ibm_db\build\Release\odbc_bindings.exp
  Generating code
  Previous IPDB not found, fall back to full compilation.
  All 559 functions were compiled because no usable IPDB/IOBJ from previous compilation was found.
  Finished generating code
  odbc_bindings.vcxproj -> C:\XYZ\Redox\node_modules\ibm_db\build\Release\\odbc_bindings.node

ibm_db installed successfully.

up to date, audited 63 packages in 21s

3 packages are looking for funding
  run `npm fund` for details

found 0 vulnerabilities
PS C:\XYZ\Redox\node_modules\ibm_db>

Tried rerunning the script and got following error -: 

PS C:\XYZ\Redox> npm run start   

> redox@1.0.0 start
> electron .

App threw an error during load
Error: The module '\\?\C:\XYZ\Redox\node_modules\ibm_db\build\Release\odbc_bindings.node'
was compiled against a different Node.js version using
NODE_MODULE_VERSION 102. This version of Node.js requires
NODE_MODULE_VERSION 106. Please try re-compiling or re-installing
the module (for instance, using `npm rebuild` or `npm install`).
    at process.func [as dlopen] (node:electron/js2c/asar_bundle:5:1812)
    at Module._extensions..node (node:internal/modules/cjs/loader:1203:18)
    at Object.func [as .node] (node:electron/js2c/asar_bundle:5:1812)
    at Module.load (node:internal/modules/cjs/loader:988:32)
    at Module._load (node:internal/modules/cjs/loader:829:12)
    at c._load (node:electron/js2c/asar_bundle:5:13343)
    at Module.require (node:internal/modules/cjs/loader:1012:19)
    at require (node:internal/modules/cjs/helpers:102:18)
    at bindings (C:\XYZ\Redox\node_modules\ibm_db\node_modules\bindings\bindings.js:112:48)
    at Object.<anonymous> (C:\XYZ\Redox\node_modules\ibm_db\lib\odbc.js:57:31)

Then I rebuild -: 

PS C:\XYZ\Redox> npm run rebuild 

> redox@1.0.0 rebuild
> electron-rebuild

⠼ Building module: ibm_db, Completed: 0Building the projects in this solution one at a time. To enable parallel build, please add the "-m" switch.
⠙ Building module: ibm_db, Completed: 0  odbc.cpp
⠏ Building module: ibm_db, Completed: 0C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(2546,1): warning C4996: 'v8::ObjectTemplate::SetAccessor': Do signature check in accessor [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\Users\abhaysin\.electron-gyp\19.0.6\include\node\v8-template.h(838): message : see declaration of 'v8::ObjectTemplate::SetAccessor' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
⠋ Building module: ibm_db, Completed: 0C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(216,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(228,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(705,73): warning C4311: 'type cast': pointer truncation from 'SQLHSTMT' to 'long' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(705,73): warning C4302: 'type cast': truncation from 'SQLHSTMT' to 'long' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(706,33): warning C4311: 'type cast': pointer truncation from 'SQLHSTMT' to 'long' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(706,33): warning C4302: 'type cast': truncation from 'SQLHSTMT' to 'long' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc.cpp(1413,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
⠏ Building module: ibm_db, Completed: 0  odbc_connection.cpp
⠧ Building module: ibm_db, Completed: 0C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(2546,1): warning C4996: 'v8::ObjectTemplate::SetAccessor': Do signature check in accessor [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\Users\abhaysin\.electron-gyp\19.0.6\include\node\v8-template.h(838): message : see declaration of 'v8::ObjectTemplate::SetAccessor' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
⠇ Building module: ibm_db, Completed: 0C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(310,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(534,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(909,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1094,60): warning C4312: 'type cast': conversion from 'int32_t' to 'SQLPOINTER' of greater size [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj 
]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1148,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1178,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1341,55): warning C4312: 'type cast': conversion from 'int32_t' to 'SQLPOINTER' of greater size [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj 
]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1714,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(1896,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_connection.cpp(2100,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
⠴ Building module: ibm_db, Completed: 0  odbc_statement.cpp
⠸ Building module: ibm_db, Completed: 0C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(2546,1): warning C4996: 'v8::ObjectTemplate::SetAccessor': Do signature check in accessor [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\Users\abhaysin\.electron-gyp\19.0.6\include\node\v8-template.h(838): message : see declaration of 'v8::ObjectTemplate::SetAccessor' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
⠼ Building module: ibm_db, Completed: 0C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(246,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(422,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1724): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(573,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(778,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(949,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(980,85): warning C4312: 'type cast': conversion from 'int32_t' to 'SQLPOINTER' of greater size [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]  
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(1047,91): warning C4312: 'type cast': conversion from 'int32_t' to 'SQLPOINTER' of greater size [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj] 
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(1121,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_statement.cpp(1244,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
⠇ Building module: ibm_db, Completed: 0C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(2546,1): warning C4996: 'v8::ObjectTemplate::SetAccessor': Do signature check in accessor [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\Users\abhaysin\.electron-gyp\19.0.6\include\node\v8-template.h(838): message : see declaration of 'v8::ObjectTemplate::SetAccessor' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_result.cpp(287,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_result.cpp(312,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\src\odbc_result.cpp(598,1): warning C4996: 'Nan::Callback::Call': was declared deprecated [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
C:\XYZ\Redox\node_modules\ibm_db\node_modules\nan\nan.h(1746): message : see declaration of 'Nan::Callback::Call' [C:\XYZ\Redox\node_modules\ibm_db\build\odbc_bindings.vcxproj]
⠴ Building module: ibm_db, Completed: 0  strptime.c
⠏ Building module: ibm_db, Completed: 0  win_delay_load_hook.cc
⠦ Building module: ibm_db, Completed: 0     Creating library C:\XYZ\Redox\node_modules\ibm_db\build\Release\odbc_bindings.lib and object C:\XYZ\Redox\node_modules\ibm_db\build\Release\odbc_bindings.exp
⠏ Building module: ibm_db, Completed: 0  odbc_bindings.vcxproj -> C:\XYZ\Redox\node_modules\ibm_db\build\Release\\odbc_bindings.node
✔ Rebuild Complete

Again tried runing the script -:

PS C:\XYZ\Redox> npm run start

> redox@1.0.0 start
> electron .

[Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified] {
  error: '[ibm_db] SQL_ERROR',
  sqlcode: 0,
  state: 'IM002'
}
bimalkjha commented 2 years ago

@techabhay366 Now you shared the complete info. From your shared output, we can see that npm install ibm_db successfully installed ibm_db. But, the npm run rebuild command has messed up. When npm install ibm_db is success, why you need to rebuild it again? After npm install ibm_db, you can update database connection info in ibm_db\test\config.testConnectionStrings.json file and execute node test\test-basic-test.js command. It'll work fine without any issue. Now, coming to your problem. It seems you are building an electron application. For that we need to use npm install ibm_db --vscode command. It is documented on ibm_db documentation page. Just search for electron.

For your case, electron-rebuild is recompiling the ibm_db code and this is not generating the correct binaries. The npm run start command should work fine for you after npm install ibm_db --vscode command, but you are not using the right version of node.js which is required for your version of electron. So, you are getting NODE_MODULE_VERSION error. Please share version of electron. Check required node.js version for your electron here: https://www.npmjs.com/package/electron-releases Install same version of node.js as per: https://www.npmjs.com/package/electron-releases Then uninstall ibm_db and reinstall using npm install ibm_db --vscode command. Now, npm run start should work. No need to do the electron-rebuild. It'll corrupt ibm_db as electron-build links ibm_db with microsoft ODBC Driver and not with IBM ODBC/CLI Driver. Hence, you are getting error message from Microsoft ODBC Driver Manager. Hope it clarifies. Thanks.

bimalkjha commented 2 years ago

@techabhay366 We have released a new version of ibm_db@2.8.2 with electron specific enhancement. I think you are using electron version 19.0.6. So, uninstall the existing ibm_db and reinstall it using npm install ibm_db -electron=19.0.6. It should work fine. Thanks.

techabhay366 commented 1 year ago

Thanks @bimalkjha , I reinstalled ibm_db@2.8.2 and it worked like charm. No changes required.