Error IM002 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[luluhoc]

Expected behaviour:

I try to connect and run a query

Actual behaviour:

Can't connect

Configuration:

const sql = require('mssql/msnodesqlv8')
const config = {
  user: 'xxxxxx',
  password: 'xxxxxx',
  server: 'xxxxxx\\SQLX12', 
  database: 'xxxxxx',
  port: 49204,
  options: {
    trustedConnection: true,
  }
};

sql.connect(config, function (err) {

  if (err) console.log(err);

  // create Request object
  var request = new sql.Request();

  // query to the database and get the records
  request.query('select * from tempdb..zIntra45_ChiAffJour', function (err, recordset) {

      if (err) console.log(err)

      // send records as a response
      console.log(recordset);

  });
});

Software versions

• NodeJS: v15.0.1
• node-mssql: "msnodesqlv8": "^1", "mssql": "^6.3.1" tried two
• SQL Server: SQL SERVER 13.0.4001 Driver ODBC VERSION SQL NATIVE 11 error

  ConnectionError: [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et nom de pilote non spécifié
  at C:\Users\admin\Desktop\mssql\node_modules\mssql\lib\msnodesqlv8\connection-pool.js:56:17
  at Immediate.<anonymous> (C:\Users\admin\Desktop\mssql\node_modules\msnodesqlv8\lib\connection.js:360:15)
  at processImmediate (node:internal/timers:462:21) {
  code: undefined,
  originalError: [Error: [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et nom de pilote non spécifié] {
  sqlstate: 'IM002',
  code: 0
  }
  }
  RequestError: No connection is specified for that request.
  at Request._query (C:\Users\admin\Desktop\mssql\node_modules\mssql\lib\base\request.js:465:37)
  at Request._query (C:\Users\admin\Desktop\mssqlnode_modules\mssql\lib\msnodesqlv8\request.js:238:11)
  at Request.query (C:\Users\admin\Desktop\mssql\node_modules\mssql\lib\base\request.js:401:12)
  at C:\Users\admin\Desktop\mssql\index.js:21:11
  at Immediate.<anonymous> (C:\Users\admin\Desktop\mssql\node_modules\mssql\lib\global-connection.js:56:7)
  at processImmediate (node:internal/timers:464:21) {
  code: 'ENOCONN'
  }
  undefined

[dhensby]

I'm not sure what is causing this, but googling the error I can see some people saying that the ODBC driver is not installed on the client machine. Are you sure your node server has the ODBC driver installed?

[dhensby]

closing due to lack of response