tediousjs / node-mssql

Microsoft SQL Server client for Node.js
https://tediousjs.github.io/node-mssql
MIT License
2.22k stars 464 forks source link

ConnectionError: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified #1612

Closed rihaskh closed 3 months ago

rihaskh commented 4 months ago

Please let me know what I am missing here in the code

const sql = require("mssql/msnodesqlv8");

const sqlConfig = {
  user: "user",
  password: "password",
  database: "dbname",
  driver: "msnodesqlv8",
  server: "server name",
  port: "1433",
  options: {
    trustedConnection: true,
  },
};

try {
  sql.connect(sqlConfig, function(err) {
    if(err) console.log(err);
    const req = new sql.Request();
    req.query("select * from student", function(err, records) {
      if (err) console.log(err);
      else console.log(records);
    });
  });
} catch (err) {
  console.log("Error in connecting database", err);
}
dhensby commented 4 months ago

Please use the issue template