how to connect to a MSSQL database using Angular version 2 with Node JS

Question

I am trying to connect to our companies current MSSQL database which hold our inhouse portal. I want to do this via node.js but I am currently having problems with trying to connect to the database.

Below is an example code from a app.module.ts file from an angular project. How would I implement connecting to a database from here?

import { BrowserModule } from '@angular/platform-browser';
import { NgModule } from '@angular/core';
import { FormsModule } from '@angular/forms';
import { HttpModule } from '@angular/http';


import { AppComponent } from './app.component';
import { ServerComponent } from './server/server.component';
import { ServersComponent } from './servers/servers.component';

@NgModule({
  declarations: [
    AppComponent,
    ServerComponent,
    ServersComponent
  ],
  imports: [
    BrowserModule,
    FormsModule,
    HttpModule
  ],
  providers: [],
  bootstrap: [AppComponent]
})
export class AppModule { 
 
}

The frontend framework has nothing to do with the MSSQL connection. If you want to do it with NodeJS have a look on the existing modules for the purpose - for example mssql — codtex
– codtex, Commented Sep 8, 2017 at 13:47

Pac0 · Accepted Answer · 2017-09-08 14:21:01Z

2

Angular (frontend) will make HTTP requests to your node.js server (backend)

Your backend server will then do whatever calls it needs to do with your MYSQL database.

The server will make whatever processing it needs to do on db results, then returns a JSON response for the request back to your Angularapp.

By itself Angular is not supposed to be connected to any database, nor it should even knows about one.

As suggested in the comments, you need to focus on how to access your DB from node.js, for instance with mssql.

Then you need need to focus on how to make HTTP requests to your server with an Angular service.

More info for example here : https://scotch.io/tutorials/creating-a-single-page-todo-app-with-node-and-angular

answered Sep 8, 2017 at 14:21

Pac0

23.3k9 gold badges76 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to connect to a MSSQL database using Angular version 2 with Node JS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related