You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
The text was updated successfully, but these errors were encountered: