const cloud = require('wx-server-sdk')
const sql = require('mssql')
cloud.init({
env: 'aaaaaa-123' //云环境ID
})
cloud.init()
// 云函数入口函数
exports.main = async (event, context) => {
try {
console.log("连接开始")
await sql.connect('Server=zzbtd.com,38299;Database=zzbtd;User Id=sa;Password=password;Encrypt=true')
//域名和端口是花生壳映射的,sql server 登录没问题
console.log("连接完毕")
const result = await sql.query`select top 1 * from workList`
console.dir("comp",result)
} catch (err) {
console.log("err",err)
}
}
云函数返回日志结果
null
日志
START
连接开始
err {
"code": "ESOCKET",
"originalError": {
"message": "Failed to connect to zzbtd.com:38299 - self signed certificate",
这里的服务器域名和端口号,为何自动改成了“:”号,按道理说应该是“,”号,这是mssql的bug么?这个问题是否是连接不成功的原因呢?
"code": "ESOCKET"
},
"name": "ConnectionError"
}
REPORT RequestId:55a226a4-26bd-11ec-8bee-ee7d125a6563 Duration:1143ms Memory:256MB MemUsage:37.125000MB
END