node-mssql

node-mssql copied to clipboard

Error on Vercel deploy

1

On deploy to vercel I am getting this error and I have mssql on package.json and locally they find   ### Software versions * NodeJS: * node-mssql: * SQL...

engJoseSilva

Can't write null to varbinary column

2

Hi, I can't write null to a varbinary column, that is allowed to contain null values. ### Expected behaviour: Insert null to a varbinary column works without throwing an error....

code4break

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

1

When using the following option set connection fails ```const config = { user: "VinVisionAPIUser", password: "VinVisionAPIPassword", //this account will most likely need creating server: SQLServerUrl, database: SQLServerDb, options: { trustServerCertificate:...

Jersh

Not able to fetch execution plan by setting `SET SHOWPLAN_XML ON` using mssql

1

I want to fetch the estimated execution plan of a query using the MSSQL package using Nodejs. As per the document https://learn.microsoft.com/en-us/sql/t-sql/statements/set-showplan-xml-transact-sql?view=sql-server-ver16 If I set the SHOWPLAN_XML to ON before...

charmi2011

Allow windows users to choose their own driver.

1

Right now windows users are stuck with the 'SQL Server Native Client 11.0' driver. Why not let developers choose whether we want the ODBC driver or the Native Client? The...

ctgbarcalow

(node:1009) MaxListenersExceededWarning: Possible EventEmitter memory leak detected. 11 error listeners added to [ConnectionPool]. Use emitter.setMaxListeners() to increase limit

1

Hi, I am trying to fetch the records in loops from mssql, ```js ql.connect(config, err => { // ... error checks const request = new sql.Request() request.stream = true //...

rajat42059

Bumps [tedious](https://github.com/tediousjs/tedious) from 16.7.0 to 18.2.0. Release notes Sourced from tedious's releases. v18.2.0 18.2.0 (2024-04-18) Bug Fixes fix bigint validation (#1620) (2b21b12) Features types: Export ConnectionAuthentication and ConnectionOptions (#1615) (d37e167),...

dependabot[bot]

Bulk Insert row lock not supported

1

Bulk insert operations are not supporting row level locks, I don't see options in IbulkOptions, As a results transactions are experiencing delays and potential deadlocks ### Expected behaviour: Bulk insert...

aburht

Request timeouts in mssql/msnodesqlv8 when using default Pool size

4

I am switching from `mssql` (Tedious) to `mssql/msnodesqlv8`, because we need Windows Authentication support in our `Node.js` service. However after switching I run into the following issue. We have a...

remz

Problem with Persian/Arabic characters when using input()

4

I noticed that there's a problem with Persian/Arabic characters when using `.input()`. > [!NOTE] > Both `ی` (Persian) and `ي` (Arabic) represent the ~same character but with different unicodes. In...

ShahriarKh