仅在某些Windows 7计算机上，没有为一个或多个必需参数给出任何值错误 [英] No values given for one or more required parameters error only on some Windows 7 machines

问题描述

你好，

我有一个VB6应用程序，可以在大多数Windows 7计算机上正常运行(即使打开了UAC)，但是对于其中一些计算机，如果程序在启动时未设置为``以管理员身份运行''，它将返回错误消息''尝试查询数据库时，没有为一个或多个必需参数提供任何值.

我知道错误消息通常意味着表名和/或参数的拼写错误.但是这里不是这种情况，因为在Win XP和某些Win 7计算机上，相同的应用程序执行相同的过程/查询调用没有问题.

该数据库是MS Access 2003格式.该数据库与应用程序exe和dll一起位于Program Files目录中.

如果这是一个一致的错误，那么我可以轻松地对其进行调试并继续下去，但是由于我的所有测试机都不会产生此错误，所以我很茫然.

关于为什么发生这种情况以及如何解决的任何想法?

谢谢，
Chris

Hello,

I have a VB6 application that works fine on most Windows 7 machines (even with UAC turned on), but for some of them if the program is not set to ''Run as administrator'' upon startup it will return the error message ''No value given for one or more required parameters'' when it tries to query the database.

I know the error message usually means that the table name(s) and/or parameter(s) are spelled incorrectly. But that is not the case here since the same application doing the same proceedures/query calls has no issues on Win XP and some Win 7 machines.

The database is MS Access 2003 format. The database is located in the Program Files directory along with the application exe and dlls.

If this was a consistant error then I could easily debug it and move on, but since all my testing machines do not generate this error, I am at a loss.

Any ideas as to why this occurs and how to fix it?

Thanks,
Chris

推荐答案

亲爱的朋友，

我认为问题出在参数上.对于参数之一，该值为null或空白，或者列名不匹配.请点击链接以获取更多详细信息:-

http://www.daniweb.com/web-development/aspnet/threads/275039 [ ^ ]

http://vbadud.blogspot.in/2009/03/no-value-given-for-one-or-more-required.html [

Dear Friend,

I think that the problem is with the parameters. For one of the parameter the value is null or blank or the column names are not matching. Please follow the links for more details:-

http://blogs.msdn.com/b/spike/archive/2010/03/04/no-value-given-for-one-or-more-required-parameters-incorrect-syntax-near-the-keyword-default.aspx[^]

http://www.daniweb.com/web-development/aspnet/threads/275039[^]

http://vbadud.blogspot.in/2009/03/no-value-given-for-one-or-more-required.html[^]

Don&''t forget to mark this as your answer if it helps you out.

Thanks

这篇关于仅在某些Windows 7计算机上，没有为一个或多个必需参数给出任何值错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！