I am trying to connect to an Access database with nuintun’s node-adodb package. I have successfully connected to it in my laptop @ home and created a dist. package to install it to my computer @ office. However after installing it to my office laptop, I am getting below error message during connection to access database.
connection string:
"Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Temp\Mdb.mdb;Persist Security Info=False;"
error message:
Error: Spawn C:WINDOWSSysWOW64cscript.exe error
I tried several connection configs to solve this but cannot get it done.
With this method (connection = ADODB.open(dbConn);) I am getting above error message.
With this connection = ADODB.open(dbConn, true) or this connection=ADODB.open(process.arch.includes('64') or this connection = ADODB.open(connection, 'x64') I am getting below error message:
Error: Spawn C:WINDOWSSystem32cscript.exe error
Any help appreciated.