node-adodb Error: Spawn C:\Windows\SysWOW64\cscript.exe

See original GitHub issue

Good afternoon, I’m having this error and I did some procedures to solve it, but I did not get many results, does anyone know how to solve it?

code below

`const ADODB = require(‘node-adodb’); ADODB.debug = true;

// Connect to the MS Access DB const connection = ADODB.open(‘Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\192.168.0.4\banco_teste\DBCIEE.mdb;’); // Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\192.168.0.4\BANCO\DBCIEE.mdb;Persist Security Info=False

//Query the DB async function query() { try{ const users = await connection.query(‘SELECT * FROM CIEE01’);

    console.log(JSON.stringify(users, null, 2));
}catch(error){
    console.error(error);
}

}

query();`

Thank’s

Issue Analytics

State:
Created 5 years ago
Comments:10

Top GitHub Comments

3reactions

RoelVBcommented, Nov 1, 2018

Do console.error(JSON.stringify(error)) instead of console.error(error). This could give you some extra information.

2reactions

mohammadfgcommented, Jun 25, 2021

use this code :

    const ADODB = require('node-adodb');
    // ADODB.debug = true;
    const connection = ADODB.open('Provider=Microsoft.ACE.Oledb.12.0;Data Source=C:\\databases\\DB.accdb;', process.arch.includes('64'));
    
    connection.query('SELECT * FROM Table1').then(data => {
        console.log(JSON.stringify(data));
    }).catch(error => {
        console.error(JSON.stringify(error))
    });