tediousjs / node-mssql

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

connection fails to SQL 2012 when specifying tdsVersion, works when left out #1468

Closed Jersh closed 7 months ago

Jersh commented 1 year ago

When using the following option set connection fails

  user: "VinVisionAPIUser",
  password: "VinVisionAPIPassword",      //this account will most likely need creating
  server: SQLServerUrl,
  database: SQLServerDb,
  options: {
    trustServerCertificate: true,
    instancename: SQLServerInsatnce,
    encrypt: false,
    tdsVersion: '7.4'  // chage this as required because we have many SQL version see: https://github.com/tediousjs/tedious
  },

however if I comment out the tdsversion option connection works

I would expect it to work, according to the tedious repo 2012 is tdsVersion 7.4

Error displays as a socket hangup error

Software versions

dhensby commented 1 year ago

Can you replicate this with the raw tedious driver?