currentdb.execute odbc - 调用失败错误＃4134 [英] currentdb.execute odbc--call failed error #4134

问题描述

Ben，



首先，这是我的工作工具：我有一个使用SQL Server数据库的Access 2003应用程序（我知道它'太奇怪了。我正在使用Microsoft SQL Server Management Studio Express。

我现在正尝试从我的应用程序执行查询，将2个表中的一些行插入到另一个表中。当我在SQL Server Management中使用它时，或者当我在Access中创建一个新查询时，我的查询运行良好，但它在我的应用程序中不起作用...它给了我ODBC调用失败。由于我的查询在其他情况下运行良好，因此出现了一个不可靠的错误：

Ben,
Hi,
First of all, here are my work tools : I have an Access 2003 app that uses an SQL Server DataBase (i know it''s weird). I am using Microsoft SQL Server Management Studio Express.
I am now trying to execute a query from my app to insert some rows from 2 tables into another. My query works well when i use it rigth into SQL Server Management or when i create a new query in Access, but it don''t work in my app... It gives me the "ODBC Call failed" error for an unkwown reason that i can''t discover because my query works well in other situations...

推荐答案

很难说是什么''没有看到代码就错了。

It''s hard to say what''s wrong without seeing the code.

如果你只在ODBC链接表上做一个简单的SELECT查询，看看你是否得到了同样的错误。这将指示问题是否与ODBC设置完全相关，或者您正在处理的实际查询是否与此问题有关。

See if you get the same error if you do a simple SELECT query on the ODBC linked table only. This will indicate whether the issue is with the ODBC setup exclusively, or whether the actual query you were working on has any bearing on the issue.

hi all，谢谢您的回复！

错误是来自服务器的超时

它被卡在下一行

CurrentDb.Execute sSql，dbSeeChanges

再次，sql没有任何问题，因为我将它复制到一个查询它工作正常，没有任何延迟！

hi to all, thanks for your reply!
the error is a timeout from the server
its being stuck at the following line
CurrentDb.Execute sSql, dbSeeChanges
again, nothing is wrong with the sql, as i copy it to a query it works fine, with no delay at all!

这篇关于currentdb.execute odbc - 调用失败错误＃4134的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！