TypeError: sql.Connection is not a function Node.js

Question

I am very beginner with node.js and javscript itself. I am trying to establish a basic connection to SQLServer but I am getting the following error:

TypeError: sql.Connection is not a function

I am following the recommendations of the mssql package git repository

//get an instance of sqlserver 
var sql = require('mssql');

//set up a sql server credentials
var config = {
server: 'localhost',
database: 'trafiyadb',
user: 'jhonycage',
password:  'juan1014',
port: 1433
};


function con() {
var dbConn = new sql.Connection(config);
dbConn.connect().then(function(){
    console.log("connected")
}).catch(function (err) {
    console.log(err);
})
}

con();

and this is the package.json

{
 "name": "trafiyaapi",
 "version": "1.0.0",
 "description": "",
 "main": "server.js\u001b[A\u001b[B\u001b[B\u001b[B\u001b[A\u001b[B",
 "dependencies": {
 "express": "^4.15.2",
 "body-parser": "^1.17.1",
 "mssql": "^4.0.4",
 "jsonwebtoken": "^7.4.0"
 },
 "devDependencies": {},
 "scripts": {
  "test": "echo \"Error: no test specified\" && exit 1",
 "start": "node server.js"
 },
 "author": "",
 "license": "ISC"
 }

I am just executing

$node server

I must be doing something wrong, how can i connect to database?

Julio Betta · Accepted Answer · 2017-05-07 04:07:41Z

5

In fact, the function Connection doesn't exist. According to the documentation, to connect to a database, you can use the class ConnectionPool, or the method connect.

var dbConn = new sql.ConnectionPool(config);

dbConn.connect(function(err) {
    // ...
});

// OR ...

sql.connect(config).then(function(dbConn) {
   // ...
})

edited May 7, 2017 at 4:07

answered May 7, 2017 at 4:00

Julio Betta

2,2951 gold badge25 silver badges25 bronze badges

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

3 Comments

Jhonycage Over a year ago

It worked indeed, thanks a bunch but now I am getting following error: { [ConnectionError: Failed to connect to localhost:1433 - Could not connect (seq uence)] code: 'ESOCKET', originalError: { [ConnectionError: Failed to connect to localhost:1433 - Could not connect ( sequence)] message: 'Failed to connect to localhost:1433 - Could not connect (sequence )', code: 'ESOCKET' }, name: 'ConnectionError' }

Julio Betta Over a year ago

Now you have to make sure that your database process is running. double check the port and try to change localhost to 127.0.0.1.

Jhonycage Over a year ago

just changed port number and server to 127.0.0.1 and is connected, I have to thank you sir for your help

Collectives™ on Stack Overflow

TypeError: sql.Connection is not a function Node.js

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related