首页 > 开发 > NodeJS > 正文

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

2017-09-08 17:10:57  来源:网友分享

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": "pleerock.me@gmail.com"  },  "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)

解决方案

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