How to Connect MSSQL with Node.js

In this tutorial, we'll explore how to connect Microsoft SQL Server (MSSQL) with Node.js using the Express framework to create an API. We'll use NPM (Node Package Manager) to install the necessary packages.

Prerequisites: Ensure you have Node.js installed on your machine.

• Setting Up the Project
• Create a new folder named dbConnection and open it in your code editor (e.g., VSCode).
• Initialize a new Node.js project by running npm init in the terminal. Press Enter for default options or use npm init -y for quick initialization.
• Install the required packages: npm install express mssql. This will add express and mssql to your project's package.json file.

• Creating the Server Create a JavaScript file named server.js and write the following code:

javascript

const express = require("express");
const sql = require("mssql");

const app = express();

// SQL Server configuration
var config = {
"user": " ", // Database username
"password": " ", // Database password
"server": " ", // Server IP address
"database": "Training", // Database name
"options": {
"encrypt": false // Disable encryption
}
}

// Connect to SQL Server
sql.connect(config, err => {
if (err) {
throw err;
}
console.log("Connection Successful!");
});

// Define route for fetching data from SQL Server
app.get("/", (request, response) => {
// Execute a SELECT query
new sql.Request().query("SELECT * FROM Employee", (err, result) => {
if (err) {
console.error("Error executing query:", err);
} else {
response.send(result.recordset); // Send query result as response
console.dir(result.recordset);
}
});
});

// Start the server on port 3000
app.listen(3000, () => {
console.log("Listening on port 3000...");
});

Explanation
We use the express and mssql packages to set up an Express server and establish a connection to MSSQL database, respectively.

The config object contains the database connection details, including the username, password, server IP, and database name. The encrypt option is set to false to disable encryption for the connection.

After establishing the connection, we define a route (/) to fetch data from the "Employee" table in the database. When this route is accessed, a SELECT query is executed to retrieve all records from the table. The query result is sent back as the response to the client.

Finally, the server is started on port 3000, and a message indicating successful startup is logged to the console.

With this setup, you can access the API endpoint (http://localhost:3000) in your browser or send HTTP requests to fetch data from the MSSQL database.

That's it! You've successfully connected MSSQL with Node.js using Express.

Now you are ready to apply in GOOGLE. 😊

NodeJS #MSSQL #Express #API #Database #Tutorial #Programming #Development #WebDevelopment #Backend #SQLServer #NodePackageManager #NPM #JavaScript #Code #SoftwareDevelopment #TechTutorial