sqlnode.jsjsonms-accessms-access-2010

Not able to run queries using nodeJS using adodb

I am trying to execute queries onto an .accdb file using node-adodb. i came across an error like this

{ Error: Spawn C:\WINDOWS\SysWOW64\cscript.exe error
at ChildProcess.child.on.exitCode (C:\Users\Sumukh Bharadwaj\Desktop\NodeJS\node_modules\node-adodb\lib\spawn.js:120:37)
at emitTwo (events.js:106:13)
at ChildProcess.emit (events.js:191:7)
at maybeClose (internal/child_process.js:891:16)
at Process.ChildProcess._handle.onexit (internal/child_process.js:226:5)


process:


{ code: -2146824582,
 message: 'Provider cannot be found. It may not be properly installed.' },


exitCode: 0 }

I'm not able to proceed further from this. Help!

Solution

  • You need a valid Access installation or an installation of the Access Database Engine to use ADO.

    Since the error refers to SysWow64, you need to install the 32-bits variant of the Access Database Engine (or Access application).