最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

Node.js中的SQL Server:查询可在服务器上运行,但不能通过Node.js驱动程序

运维笔记admin12浏览0评论

Node.js中的SQL Server:查询可在服务器上运行,但不能通过Node.js驱动程序

Node.js中的SQL Server:查询可在服务器上运行,但不能通过Node.js驱动程序

以下查询是由脚本生成的,插入到我们的SQL Server中,然后登录到控制台。

字段是匿名的:

INSERT INTO
  T_OUTLOOK_Kalendereintrag (
    field1,
    field2,
    field3,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    [fieldN WithSpace],
    [fieldN WithSpace],
    [fieldN WithSpace],
    [fieldN WithSpace],
    [fieldN WithSpace],
    [fieldN WithSpace],
    [fieldN WithSpace],
    [fieldN WithSpace],
    [fieldN WithSpace],
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN,
    fieldN
  )
VALUES
  (
    'a2714a8c-3718-42db-87b5-e5c570f84151',
    null,
    '1355',
    '06.08.2019 00:00:00',
    '201908',
    '06.08.2019 12:58:00',
    '06.08.2019 18:58:00',
    6,
    'Comment field',
    'test',
    '0900',
    '0900',
    null,
    null,
    0.75,
    6,
    0,
    'PT',
    'R4200',
    0,
    0,
    null,
    null,
    0,
    0,
    '',
    0,
    'Jane Doe',
    '20.09.2019 11:03:41',
    '20.09.2019 11:03:41',
    null,
    null,
    null,
    'Jane Doe',
    null,
    null,
    null,
    1,
    1,
    '1',
    '1',
    '20.09.2019 11:03:41',
    '20.09.2019 11:03:41',
    0
  )

通过以下代码插入服务器时

        try {
            await sql.connect(`mssql://${config.get('config.dbConfig.user')}:${config.get('config.dbConfig.pw')}@${config.get('config.dbConfig.server')}/${config.get('config.dbConfig.dbTest')}`); 

            result = await sql.query(sqlQuery);
            sql.close();

        } catch (e) {
            sql.close();
            logger.error(e);
            console.log(e);
        }

我收到以下错误:

  { number: 242,
    state: 3,
    class: 16,
    message:
     'The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.',
    serverName: 'hostname',
    procName: '',
    lineNumber: 1,
    name: 'ERROR',
    event: 'errorMessage' } },

但是,当进行上述查询并直接通过HeidiSQL查询时,一切正常吗?有任何想法吗?我找不到错误,也找不到该错误。

回答如下:
发布评论

评论列表(0)

  1. 暂无评论