问题描述
我在C ++应用程序中有一个奇怪的行为.它通过DAO连接到Access 2010数据库. Access数据库的表已通过ODBC链接到SQL Server2008.
当我在一个表上运行一个包含BETWEEN语句的特定查询，然后在另一个表上运行另一个也包含BETWEEN语句的查询时，第二个查询将失败，并显示ODBC错误，表明语法不正确.此后，ODBC驱动程序将不断继续返回语法错误.
但是，如果我先运行第二个查询，则运行任何查询都没有问题.只要会话正在运行，就不会显示任何错误.
我试图通过ODBC管理器跟踪ODBC，但是由于跟踪似乎锁定了我的应用程序，因此未成功.
Hi,
I have got a strange behavior within a c++ application. It connects through DAO to an Access 2010 database. The Access database has got its tables linked to a SQL Server 2008 through ODBC.
When I run a particular query, containing a BETWEEN-statement, on one table before running another query, also containing a BETWEEN-statement, on another table, the second query will fail with ODBC errors indicating that the syntax is incorrect. The ODBC driver will constantly continue to return syntax error after this.
But if I run the second query first, there are no problems running any of the queries. No error will be displayed as long as the session is running.
I tried to trace the ODBC through the ODBC Manager, but was unsuccessful since the tracing seemed to lock my application.
Any ideas on how to find out what is going wrong?
推荐答案
这篇关于ODBC的运行方式不同，具体取决于查询运行时的顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！