node-mssql
node-mssql copied to clipboard
tediousjs
Microsoft SQL Server client for Node.js
### Expected behaviour: I expected to read the documentation and be able to efficiently and accurately create a connection pool that uses Windows integrated login. ### Actual behaviour: After attempting...
We are getting intermittent database errors in PROD. We are able to reproduce them in different environments and here it the full stack trace. ``` RequestError: Timeout: Request failed to...
### Expected behaviour: The use of useColumnNames should not thrown an error on query ### Actual behaviour: ``` TypeError: columns is not iterable at Request. (/home/user/dev/rece-tech-web-bo/node_modules/mssql/lib/tedious/request.js:600:29) at Request.emit (node:events:527:28) at...
I am trying to connect to ms sql using below code but I am getting error. ```js const sql = require("mssql"); (async () => { try { // make sure...
### Expected behaviour: Successful connection when "Active Directory Password" is specified in the connection string Example: ```ts const connectionString = "Server=test.database.windows.net;Database=master;Authentication=Active Directory Password;User [email protected];Password=abcd"; mssql.connect(connectionString); ``` See https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.connectionstring?view=dotnet-plat-ext-7.0 for allowed...
What this does: BigInts should be treated as strings to ensure no precision loss Related issues: Attempt to fix #1385 Pre/Post merge checklist: - [x] Update change log
It seems that either the [documentation](https://github.com/tediousjs/node-mssql#handling-duplicate-column-names) on how duplicate column names are handled is incorrect, or the implementation is incorrect. Documentation notes: > If your queries contain output columns with...
Type hinting is very helpful and reducing debugging time. In this case I'd very like if TS type hinting could point to obvious errors on the `execute` stage Example -...
I have tried to create a bulk insert and struggled more hours than I willing to admit to understand why I am receiving the following error on every attempt: ```...
We currently have `debug` as a prod dependency as calls to it are scattered through our code. This isn't great. We should have a reporter function we call that the...