Connect to MSSQL - to ODBC or not to ODBC?

Post Reply
r.zegwaard
Member
Posts: 93
Joined: Fri Jul 08, 2011 10:31 am
Location: The Netherlands

Connect to MSSQL - to ODBC or not to ODBC?

Post by r.zegwaard »

Hi

I will need to connect to a MSSQL database in some NodeJS scripts.
There are ODBC packages as well as MSSQL packages available for NodeJS
Does anyone have any experience with these packages?
I would like to know how they differ in speed and stability.
We will run many queries with small result-sets.

Robert
User avatar
foxpalace
Member
Posts: 33
Joined: Fri Jan 14, 2011 12:25 pm
Location: Germany

Re: Connect to MSSQL - to ODBC or not to ODBC?

Post by foxpalace »

Hi,
iiiiiiih ms... ;)
I would prefer mssql

Code: Select all

npm install mssql
https://www.npmjs.com/package/mssql
Good examples with promise - for MariaDB I use mysql2
stargazerllc
Newbie
Posts: 12
Joined: Mon Jan 25, 2021 8:24 pm

Re: Connect to MSSQL - to ODBC or not to ODBC?

Post by stargazerllc »

https://sequelize.org/

This is a great ORM for node. It will connect to a mssql db and return an object.
Post Reply