Wednesday, June 21, 2023

connectnodejs

 var sql = require("mssql");


var config = {
  user: "sa",
  password: "Welcome@123",
  server: "NATTUTHURAI\\SQLEXPRESS",
  database: "eventmanagement",
  port: "1433",
  dialect: "mssql",
  dialectOptions: {
    instanceName: "SQLEXPRESS",
  },
};

(async () => {
  try {
    let pool = await sql.connect(config);
    const request = pool.request();
    request.query("select * from Sales", (err, result) => {
      console.dir(result);
    });
  } catch (err) {
    console.log("This is Error");
    console.log(err);
    console.dir(err);
  }
})();

sql.on("error", (err) => {
  console.log("This is Error handler");
});

No comments:

101% shares

101% shares
about me