Cannot find module 'msnodesqlv8/types' or its corresponding type declarations.

[melleck]

I have installed msnodesqlv8 but when I am trying to run the following script I am getting the error "Cannot find module 'msnodesqlv8/types' or its corresponding type declarations." on the first import line against 'msnodesqlv8/types'. Please help as this is something urgent I am using node version v21.4.0

import { SqlClient } from 'msnodesqlv8/types'

const sql: SqlClient = require('msnodesqlv8')

const connectionString = 'server=.;Database=Master;Trusted_Connection=Yes;Driver={SQL Server Native Client 11.0}'
const query = 'SELECT name FROM sys.databases'

sql.query(connectionString, query, (err, rows) => {
if (err != null) {
console.error(err)
} else {
console.log(rows)
}
})

[TimelordUK]

sorry did not respond earlier

with latest version 4.2.1

can you try something like this - or it should work if you add @tsignore above the /types import

import sql from 'msnodesqlv8'
import Connection = MsNodeSqlV8.Connection
import ConnectionPromises = MsNodeSqlV8.ConnectionPromises
async function t() {
    const connectString = 'Driver={ODBC Driver 18 for SQL Server}; Server=DESKTOP-VIUCH90;UID=linux; PWD=linux; Database=node;Encrypt=no'
    const con:Connection = await sql.promises.open(connectString)
    const promises:ConnectionPromises  = con.promises
    const res = await promises.query('select @@servername as server')
    console.log(JSON.stringify(res, null, 4))
    await con.promises.close()
}

t().then(() => {
    console.log('closed')
})

[grajesh690]

@TimelordUK If I run the above I'm getting MsNodeSqlV8 is not defined

[TimelordUK]

typescript
https://github.com/TimelordUK/msnodesqlv8_ts_sample

javascript
https://github.com/TimelordUK/msnodesqlv8_yarn_sample