Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const sql = require('mssql');
- const express = require('express')
- const app = express()
- var config = {
- userName: 'user' ,
- password: 'pass',
- domain: "AD",
- server: serversIP,
- database: 'test',
- port: 2222,
- debug: true,
- driver: 'tedious',
- options: {
- database:"test",
- instanceName : "instance"
- }
- }
- app.get("/getUsers" , (req, res)=>{
- sql.connect(config, function (err) {
- var request = new sql.Request();
- if (err) {
- console.log(err);
- return;
- }
- req.query("SELECT * FROM test").then(function (recordset) {
- console.log(recordset);
- conn.close();
- })
- .catch(function (err) {
- console.log(err);
- conn.close();
- });
- })
- });
Add Comment
Please, Sign In to add comment