首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >我需要帮助理解mssql和nodejs的错误。

问我需要帮助理解mssql和nodejs的错误。
EN

Stack Overflow用户
提问于 2017-04-27 10:26:20
回答 1查看 1.7K关注 0票数 0

所以我就是这样建立我的联系的。请记住,config.mssql在我的config.js文件中,其中有我需要使用的所有连接属性,比如数据库、用户名、端口和密码。

代码语言:javascript
复制
var connection = new sql.connect(config.mssql);
    var request = new sql.Request(connection);
    request.query('Insert into Campionamento_Contratto (Camp_Nome,Camp_Cognome,Camp_TelFisso,Camp_Cellulare,Camp_Note, Camp_UserInsert) values ('+req.body.campNome+','+req.body.campCognome+','+req.body.campTel+','+req.body.campCel+','+ req.body.campNote+','+req.user.username+')',
        function(err) {
            if (err) {
                console.log(err);
            }
            console.log(connection);
            res.redirect(301, '/home');

        }
    );

这是我的日志。所以,如果你能提前帮我做solution>,我真的会学得很好。

代码语言:javascript
复制
green-camp-7 { ConnectionError: Connection is closed.
green-camp-7     at ConnectionError (/opt/green-camp/node_modules/mssql/lib/base.js:1428:7)
green-camp-7     at Request._query (/opt/green-camp/node_modules/mssql/lib/base.js:1300:37)
green-camp-7     at Request._query (/opt/green-camp/node_modules/mssql/lib/tedious.js:497:11)
green-camp-7     at Request.query (/opt/green-camp/node_modules/mssql/lib/base.js:1243:12)
green-camp-7     at /opt/green-camp/routes/home.js:21:13
green-camp-7     at Layer.handle [as handle_request] (/opt/green-camp/node_modules/express/lib/router/layer.js:95:5)
green-camp-7     at next (/opt/green-camp/node_modules/express/lib/router/route.js:137:13)
green-camp-7     at isAuthenticated (/opt/green-camp/middleware/isAuthenticated.js:8:16)
green-camp-7     at Layer.handle [as handle_request] (/opt/green-camp/node_modules/express/lib/router/layer.js:95:5)
green-camp-7     at next (/opt/green-camp/node_modules/express/lib/router/route.js:137:13)
green-camp-7     at Route.dispatch (/opt/green-camp/node_modules/express/lib/router/route.js:112:3)
green-camp-7     at Layer.handle [as handle_request] (/opt/green-camp/node_modules/express/lib/router/layer.js:95:5)
green-camp-7     at /opt/green-camp/node_modules/express/lib/router/index.js:281:22
green-camp-7     at Function.process_params (/opt/green-camp/node_modules/express/lib/router/index.js:335:12)
green-camp-7     at next (/opt/green-camp/node_modules/express/lib/router/index.js:275:10)
green-camp-7     at Function.handle (/opt/green-camp/node_modules/express/lib/router/index.js:174:3)
green-camp-7     at router (/opt/green-camp/node_modules/express/lib/router/index.js:47:12)
green-camp-7     at Layer.handle [as handle_request] (/opt/green-camp/node_modules/express/lib/router/layer.js:95:5)
green-camp-7     at trim_prefix (/opt/green-camp/node_modules/express/lib/router/index.js:317:13)
green-camp-7     at /opt/green-camp/node_modules/express/lib/router/index.js:284:7
green-camp-7     at Function.process_params (/opt/green-camp/node_modules/express/lib/router/index.js:335:12)
green-camp-7     at next (/opt/green-camp/node_modules/express/lib/router/index.js:275:10) code: 'ECONNCLOSED', name: 'ConnectionError' }
green-camp-7 Promise {
green-camp-7   <rejected> TypeError: Invalid server: undefined
green-camp-7     at new Connection (/opt/green-camp/node_modules/tedious/lib/connection.js:71:13)
green-camp-7     at base.Promise (/opt/green-camp/node_modules/mssql/lib/tedious.js:212:23)
green-camp-7     at ConnectionPool._poolCreate (/opt/green-camp/node_modules/mssql/lib/tedious.js:177:12)
green-camp-7     at ConnectionPool._connect (/opt/green-camp/node_modules/mssql/lib/base.js:241:10)
green-camp-7     at PromiseLibrary (/opt/green-camp/node_modules/mssql/lib/base.js:217:19)
green-camp-7     at ConnectionPool.connect (/opt/green-camp/node_modules/mssql/lib/base.js:216:12)
green-camp-7     at new connect (/opt/green-camp/node_modules/mssql/lib/base.js:1600:27)
green-camp-7     at Object.<anonymous> (/opt/green-camp/routes/home.js:7:18)
green-camp-7     at Module._compile (module.js:541:32)
green-camp-7     at Object.Module._extensions..js (module.js:550:10)
green-camp-7     at Module.load (module.js:458:32)
green-camp-7     at tryModuleLoad (module.js:417:12)
green-camp-7     at Function.Module._load (module.js:409:3)
green-camp-7     at Function._load (/root/.nvm/versions/node/v6.3.1/lib/node_modules/pm2/node_modules/pmx/lib/transaction.js:62:21)
green-camp-7     at Module.require (module.js:468:17)
green-camp-7     at require (internal/module.js:20:19)
green-camp-7     at Object.<anonymous> (/opt/green-camp/app.js:43:12)
green-camp-7     at Module._compile (module.js:541:32)
green-camp-7     at Object.Module._extensions..js (module.js:550:10)
green-camp-7     at Module.load (module.js:458:32)
green-camp-7     at tryModuleLoad (module.js:417:12)
green-camp-7     at Function.Module._load (module.js:409:3) }
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2017-04-27 10:44:12

更改主机:“myhost”-转到mssql server的实际IP地址或使用localhost

代码语言:javascript
复制
host: '127.0.0.1' //for example

但你的其他证件看起来也不对。它必须是mssql server的真实端口和用户名、密码和数据库名。

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/43655123

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档