Styjun

Map a function that takes arguments in different levels of a list

Why are Latin and Sanskrit called dead languages?

What percentage of the mass/energy of the universe is in the form of electromagnetic waves?

Is it rude to ask my opponent to resign an online game when they have a lost endgame?

garage light with two hots and one neutral

Why KVM VPS is slower then OPENVZ

What happens if you just start drawing from the Deck of Many Things without declaring any number of cards?

How to run a command 1 out of N times in Bash

Is torque as fundamental a concept as force?

Is it safe for a student to give negative feedback in student evaluations?

Why didn't Thatcher give Hong Kong to Taiwan?

Using font to highlight a god's speech in dialogue

How do I stop making people jump at home and at work?

When making yogurt, why doesn't bad bacteria grow as well?

How do you manage to study and have a balance in your life at the same time?

Calculate Landau's function

Some questions about Lightning and Tor

Is mathematics truth?

Where is the correct position to set right or left of muscle names for anatomical names?

co-son-in-law or co-brother

How does Harry wear the invisibility cloak?

Updating multiple vector points at once with vertex editor in QGIS?

Meaning of "educating the ice"

'Hard work never hurt anyone' Why not 'hurts'?

mssql ConnectionPool request() exception NOT A FUNCTION

How can I use a single mssql connection pool across several routes in an Express 4 web application?In Node.js, how do I “include” functions from my other files?How is an HTTP POST request made in node.js?Node.js Best Practice Exception Handlingmap function for objects (instead of arrays)How to show data from mysql in nodejs with a refresh rateNode JS and SQL Server 2008 R2 ExpressWhy this error coming while running nodejs server?Undefined _id populate with express, moongose/MongoDB on NodejsWait for data from external API before making POST requestWhy express.Router() while separating routes

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I followed this question here using mssql 5.0.4

How can I use a single mssql connection pool across several routes in an Express 4 web application?

and I always get the

pool.request() is not a function

exception. What did I do wrong.

Exactly same 'db.js'

const sql = require('mssql')
const config = /*...*/

const poolPromise = new sql.ConnectionPool(config)
 .connect()
 .then(pool => 
 console.log('Connected to MSSQL')
 return pool
 )
 .catch(err => console.log('Database Connection Failed! Bad Config: ', err))

module.exports = 
 sql, poolPromise

and the call at:

const poolPromise = require('./db')

module.exports = 
 get: async (req, res) => 
 try 
 const pool = await poolPromise
 // RUNTIME ERROR EXCEPTION at the following line
 const result = await pool.request()
 .query('select * from cars') 

 res.json(result.recordset)
 catch (err) 
 res.status(500)
 res.send(err.message)
 
 )

node.js sql-server

share|improve this question

asked Mar 28 at 1:45

TX TTX T

43411 gold badge88 silver badges2323 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You never declared the pool.request function. On the link you just posted, check routes/set1.js file.
  
  – Rasnick
  Mar 28 at 2:55
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Rasnick, what do you mean I did not declare the pool.request. It is under the comment // RUNTIME ...
  
  – TX T
  Mar 28 at 3:13
  

  
  
  
  

add a comment | 

0

I followed this question here using mssql 5.0.4

How can I use a single mssql connection pool across several routes in an Express 4 web application?

and I always get the

pool.request() is not a function

exception. What did I do wrong.

Exactly same 'db.js'

const sql = require('mssql')
const config = /*...*/

const poolPromise = new sql.ConnectionPool(config)
 .connect()
 .then(pool => 
 console.log('Connected to MSSQL')
 return pool
 )
 .catch(err => console.log('Database Connection Failed! Bad Config: ', err))

module.exports = 
 sql, poolPromise

and the call at:

const poolPromise = require('./db')

module.exports = 
 get: async (req, res) => 
 try 
 const pool = await poolPromise
 // RUNTIME ERROR EXCEPTION at the following line
 const result = await pool.request()
 .query('select * from cars') 

 res.json(result.recordset)
 catch (err) 
 res.status(500)
 res.send(err.message)
 
 )

node.js sql-server

share|improve this question

asked Mar 28 at 1:45

TX TTX T

43411 gold badge88 silver badges2323 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You never declared the pool.request function. On the link you just posted, check routes/set1.js file.
  
  – Rasnick
  Mar 28 at 2:55
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Rasnick, what do you mean I did not declare the pool.request. It is under the comment // RUNTIME ...
  
  – TX T
  Mar 28 at 3:13
  

  
  
  
  

add a comment | 

I followed this question here using mssql 5.0.4

How can I use a single mssql connection pool across several routes in an Express 4 web application?

and I always get the

pool.request() is not a function

exception. What did I do wrong.

Exactly same 'db.js'

const sql = require('mssql')
const config = /*...*/

const poolPromise = new sql.ConnectionPool(config)
 .connect()
 .then(pool => 
 console.log('Connected to MSSQL')
 return pool
 )
 .catch(err => console.log('Database Connection Failed! Bad Config: ', err))

module.exports = 
 sql, poolPromise

and the call at:

const poolPromise = require('./db')

module.exports = 
 get: async (req, res) => 
 try 
 const pool = await poolPromise
 // RUNTIME ERROR EXCEPTION at the following line
 const result = await pool.request()
 .query('select * from cars') 

 res.json(result.recordset)
 catch (err) 
 res.status(500)
 res.send(err.message)
 
 )

node.js sql-server

share|improve this question

asked Mar 28 at 1:45

TX TTX T

43411 gold badge88 silver badges2323 bronze badges

pool.request() is not a function

const sql = require('mssql')
const config = /*...*/

const poolPromise = new sql.ConnectionPool(config)
 .connect()
 .then(pool => 
 console.log('Connected to MSSQL')
 return pool
 )
 .catch(err => console.log('Database Connection Failed! Bad Config: ', err))

module.exports = 
 sql, poolPromise

const poolPromise = require('./db')

module.exports = 
 get: async (req, res) => 
 try 
 const pool = await poolPromise
 // RUNTIME ERROR EXCEPTION at the following line
 const result = await pool.request()
 .query('select * from cars') 

 res.json(result.recordset)
 catch (err) 
 res.status(500)
 res.send(err.message)
 
 )

node.js sql-server

node.js sql-server

share|improve this question

asked Mar 28 at 1:45

TX TTX T

43411 gold badge88 silver badges2323 bronze badges

share|improve this question

asked Mar 28 at 1:45

TX TTX T

43411 gold badge88 silver badges2323 bronze badges

asked Mar 28 at 1:45

TX TTX T

43411 gold badge88 silver badges2323 bronze badges

asked Mar 28 at 1:45

TX TTX T

43411 gold badge88 silver badges2323 bronze badges