TypeORM连接sqlserver的时候报一个错，大家帮忙看下是什么原因

Question

package.json文件

---

{
  "name": "typeorm-typescript-koa-example",
  "version": "0.0.1",
  "description": "Example how to use Koa and TypeORM with TypeScript.",
  "license": "MIT",
  "readmeFilename": "README.md",
  "author": {
    "name": "Umed Khudoiberdiev",
    "email": "[e-mail]"
  },
  "repository": {
    "type": "git",
    "url": "https://github.com/typeorm/typescript-koa-example.git"
  },
  "bugs": {
    "url": "https://github.com/typeorm/typescript-koa-example/issues"
  },
  "tags": [
    "orm",
    "typescript",
    "typescript-orm",
    "typeorm-sample",
    "typeorm-example",
    "typeorm-koa-example"
  ],
  "devDependencies": {
    "typescript": "^2.1.5"
  },
  "dependencies": {
    "@types/koa": "^2.0.39",
    "@types/koa-bodyparser": "^3.0.24",
    "@types/koa-router": "^7.0.23",
    "@types/node": "^8.0.26",
    "body-parser": "^1.17.2",
    "koa": "^2.3.0",
    "koa-bodyparser": "^4.2.0",
    "koa-router": "^7.2.1",
    "mssql": "^4.0.4",
    "node-mssql": "0.0.1",
    "reflect-metadata": "^0.1.10",
    "typeorm": "0.0.11"
  },
  "scripts": {
    "start": "tsc && node src/index.js"
  }
}

---

ormconfig.json

---

[
  {
    "name": "default",
    "driver": {
      "type": "mssql",
      "host": "127.0.0.1",
      "port": 3000,
      "username": "sa",
      "password": "wangliao123",
      "database": "TF_DW"
    },
    "autoSchemaSync": false,
    "entities": [
      "src/entity/*.js"
    ],
    "subscribers": [
      "src/subscriber/*.js,"
    ],
    "migrations": [
      "src/migration/*.js"
    ],
    "cli": {
      "entitiesDir": "src/entity",
      "migrationsDir": "src/migration",
      "subscribersDir": "src/subscriber"
    }
  }
]

---

报错信息

---

TypeORM connection error:  TypeError: _this.mssql.Connection is not a constructor
    at D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\driver\sqlserver\SqlServerDriver.js:98:30
    at Promise (<anonymous>)
    at SqlServerDriver.connect (D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\driver\sqlserver\SqlServerDriver.js:97:16)
    at Connection.<anonymous> (D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\connection\Connection.js:165:58)
    at step (D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\connection\Connection.js:32:23)
    at Object.next (D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\connection\Connection.js:13:53)
    at D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\connection\Connection.js:7:71
    at Promise (<anonymous>)
    at __awaiter (D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\connection\Connection.js:3:12)
    at Connection.connect (D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\connection\Connection.js:157:16)

---

Answer 1

这个是mssql的版本问题，4.x版本对3.x版本的一些方法不支持了，改用mssql 3.3.0版本就好了