Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const express = require('express')
- const sql = require('mssql');
- const Connection = require('tedious').Connection;
- var config = {
- userName: 'user' ,
- password: 'pass',
- domain: "AD",
- server: serversIP,
- database: 'test',
- port: 2222,
- debug: true,
- driver: 'tedious',
- options: {
- database:"test",
- instanceName : "instance"
- }
- }
- var connection = new Connection(config);
- connection.on('connect', function(err) {
- if (err) {
- console.log(err);
- } else {
- console.log("server is connected to DB")
- }}
- );
- app.get("/" , (req, res)=>{
- new sql.Request().query(`SELECT * FROM test `, (err, recordset) => {
- if (err) {
- console.log(err);
- return;
- }
- else {
- res.send(JSON.stringify(recordset));
- }
- });
- request.query();
- });
- app.get("/getUsers", (req, res)=>{
- sql.connect(config, function (err) {
- var request = new sql.Request();
- if (err) {
- console.log(err);
- return;
- }
- new sql.query(`SELECT * FROM dbo.tblDatabaseUserIDs_lookup `, (err, recordset) => {
- console.log("first error msg");
- if (err) {
- console.log(err);
- return;
- }
- else {
- console.log("second error msg");
- res.send(JSON.stringify(recordset));
- }
- });
- console.log("3rd error msg");
- //req.query();
- });
- });
- sql.connect(config, function (err) {
- var request = new sql.Request();
- if (err) {
- console.log(err);
- return;
- }
- ...connection.callProcedure(function (err) {
- new sql.query(`SELECT * ....
- connection.commitTransaction
Add Comment
Please, Sign In to add comment