發表文章

目前顯示的是 12月, 2021的文章

Nodejs Failed to connect to localhost:1433 - Could not connect

圖片
  1. Nodejs npm install express npm install  mssql var express=require( 'express' ); var app=express(); app.get( '/' , function (req,res){     var sql=require( 'mssql' );         //config for your database     var config={        user: 'sa' ,        password: 'XXXX' ,        server: 'localhost' ,   //這邊要注意一下!!         //server: 'LAPTOP-G08D86D1',        database: 'CULA' ,        trustServerCertificate: true     };         //connect to your database     sql.connect(config, function (err) {       if (err) console.log(err);         //create Request object       var request= new sql.Request();    request.query( 'select * from CulaClinic' , function (err,recordset){       if (err) console.log(err); ...