Keep saying Module not found of sqlserverv8

[carltin0315]

I installed this lib with setting NODE_TLS_REJECT_UNAUTHORIZED with 0. But when I call it, it says:

./node_modules/msnodesqlv8/lib/util.js:5:20 Module not found: Can't resolve '../build/Release/sqlserverv8'

I ensure the sqlserverv8.node exist inside the node_modules. But it just keep saying module not found.

I'm using it in a next.js web application and here is my code:

`import sql from "mssql/msnodesqlv8";

const conn = new sql.connect( { database: "db_name", server: "1.1.1.1", driver: "msnodesqlv8", options: { encrypt: false, trustedConnection: true, }, }, (err) => { if (err) { console.log(Error while connecting database: ,${err}); } else { console.log(connected to database); } } ); export { conn }; `

[DaveMcNamara]

I am also seeing this, the issue began when I upgraded Node to LTS (18.16.1).

I got it to work by going into /lib/util.js and changing the require path for cppDriver to include the file extension. So, changing '../build/Release/sqlserverv8' to '../build/Release/sqlserverv8.node'. Not a legit solution, but good enough for my current purposes and maybe good info on what's not working here.

[carltin0315]

by going into /lib/util.js and changing the require path for cppDriver to inc

Not work for me. It gives me same error of Module not found: Can't resolve '../build/Release/sqlserverv8'

[henriquedpn]

It didn't work for me either. I can even delete the util.js file, change whatever inside it, clean npm cache and it still fail to compile with same error. is there any other cache I should clean?

[muhaimincs]

what is the right approach after successfully npm install? I think docs are too much information and misleading too

[TimelordUK]

looks similar to this issue which can be fixed as described

[TimelordUK]

https://github.com/TimelordUK/node-sqlserver-v8/releases

look at release notes this should now sort out NextJS based problems