MSOLEDBSQL和Shape SQL的问题 [英] Problems with MSOLEDBSQL and Shape SQL

问题描述

这个实现中似乎有一些空白ADO

There seem to be a few gaps in this implementation with ADO

1）如果sql是参数化形状SQL， 驱动程序无法识别附加形状选择中的参数。

   一个参数未指定错误。 相同的形状SQL适用于SQLOLEDB.1

1) If the sql is parameterized shape SQL,  the driver will not recognize parameters in appended shape selects.
    One gets a parameter not specified error.  Same Shape SQL works fine with SQLOLEDB.1

2）   如果子查询包含对临时表的引用，则会得到无效的对象错误。 Sql跟踪显示SPID在父查询
和子查询之间发生了变化（它解释了错误，但为什么要更改？）。      SQLOLEDB不存在这些问题，即使是MSOLEDBSQL如果参数和
临时表仅出现在顶部查询中。

2)  If the child query contains a reference to a temp table, we get an invalid object error. Sql trace shows that the SPID changes between the parent query and the child (it explains the error but why the change?).    These issues do not exist with SQLOLEDB or, even with MSOLEDBSQL if parameter and temp table appear only in the top query.

任何使MSOLEDBSQL在这些情况下都能正常工作的努力将不胜感激。

Any effort to make MSOLEDBSQL work in these circumstances would be greatly appreciated.

推荐答案

如果你坚持旧的ADO，我认为你应该坚持使用旧的SQLOLEDB。我无法想象这是新提供商支持20年历史的API的设计目标。

If you stick to old ADO, I think you should stick to old SQLOLEDB. I can't imagine that it was a design goal for the new provider to support a 20 year old API.

这篇关于MSOLEDBSQL和Shape SQL的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！