i get the error , i dont understand, it works for normal queries, but for procedures, i get this error
TypeError: connection.on is not a function
at D:project_digitalbackendnode_modulesmssqllibtediousrequest.js:792:20
at D:project_digitalbackendnode_modulesmssqllibbaseconnection-pool.js:371:41
at runNextTicks (node:internal/process/task_queues:60:5)
at process.processImmediate (node:internal/timers:447:9)
Relevant codes:
import sql from 'mssql/msnodesqlv8.js';
const config = {
server: 'DESKTOP-5FI8O0F\SQLEXPRESS',
database: 'logs',
options: {
trustedConnection: true,
},
driver: 'msnodesqlv8',
};
async function connectToDatabase() {
try {
console.log('Attempting to connect to SQL Server...');
const pool = await sql.connect(config);
console.log('Connected to SQL Server');
return pool;
} catch (error) {
console.error('Database connection failed:', error.message);
throw error;
}
}
connectToDatabase()
export { connectToDatabase };
app.get('/model_size_shift_counts1', async (req, res) => {
try {
const pool = await connectToDatabase();
const request = pool.request();
const result = await request.execute(`GetModelSizeShiftCountsBetweenDates1`);
res.json(result.recordset);
await pool.close();
} catch (err) {
console.error(err);
res.status(500).send('Internal Server Error');
}
});
I don’t understand the problem here, please help
New contributor
santosh nandan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.