I'm using your package into my NodeJS v.8.10 project on serverside to read data from MS Access file. I call API to Node server to execute db.openSync(), db.querySync() and db.closeSync() to query data in a table. It work fine but when I call API faster and continous (4 -5 requests). It throw an error from your odbc.js file at line 336 in Database.prototype querySync function.
Error at Line : syntax error near /V
syntax error near /V
Got no result for 'select * from users /V' command
{ Error: Couldn't parse SQL
at Database.querySync (/home/tuan/picking/Source/node_modules/odbc/lib/odbc.js:336:24)
at TestFuncController.testFunc (/home/tuan/picking/Source/app/Controllers/Http/Api/TestFuncController.js:13:23)
But: my code is
let Db = new ODBC()
let cnnStr = 'DRIVER={MDBTools};DBQ=/home/tuan/access_db/logindb.accdb'
Db.openSync(cnnStr)
if (Db.connected) {
let rows = Db.querySync('select * from users ')
Db.closeSync()
return response.apiSuccess(rows)
}
syntax error near /V
Got no result for 'select * from users /V' command
I don't have '/V' character in my query string.
I'm using your package into my NodeJS v.8.10 project on serverside to read data from MS Access file. I call API to Node server to execute db.openSync(), db.querySync() and db.closeSync() to query data in a table. It work fine but when I call API faster and continous (4 -5 requests). It throw an error from your odbc.js file at line 336 in Database.prototype querySync function.
Error at Line : syntax error near /V syntax error near /V Got no result for 'select * from users /V' command { Error: Couldn't parse SQL
But: my code is
syntax error near /V Got no result for 'select * from users /V' command I don't have '/V' character in my query string.