- update packages to latest
- fix for node-gyp build on node 22, node 23
import sql from 'msnodesqlv8'
import Connection = MsNodeSqlV8.Connection
import ConnectionPromises = MsNodeSqlV8.ConnectionPromises
async function t() {
const connectionString = "Driver={ODBC Driver 17 for SQL Server};Server=(localdb)\\node;Database=scratch;Trusted_Connection=yes;"
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')
})
const connectionString = "Driver={ODBC Driver 17 for SQL Server};Server=(localdb)\\node;Database=scratch;Trusted_Connection=yes;"
const sql = require('msnodesqlv8')
const query = 'SELECT top 2 * FROM syscolumns'
async function runner() {
console.log(`using connection '${connectionString}' run query '${query}'`)
const res = await sql.promises.query(connectionString, query)
console.log(JSON.stringify(res, null, 4))
}
runner().then(() => {
console.log('done.')
}).catch(e => {
console.error(e)
})
![image](https://private-user-images.githubusercontent.com/7300251/326179251-8d7e194f-c3de-4eaf-9048-40d18e1083a5.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg5MzQ0MzQsIm5iZiI6MTczODkzNDEzNCwicGF0aCI6Ii83MzAwMjUxLzMyNjE3OTI1MS04ZDdlMTk0Zi1jM2RlLTRlYWYtOTA0OC00MGQxOGUxMDgzYTUucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI1MDIwNyUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNTAyMDdUMTMxNTM0WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9MmI5NzU1Mzg2NGY0YmNmZWZjNzRjN2E0MzUxMmEyZWMzZTkxYjg0ZDlmZTVmM2I2Mzg3ODZmMjgzNTU4YWIyMSZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.Cw6UfB7TVMGA-9-n1H7vWV6PSlZ_oySkNr6MdbtLd3M)