如何解决ADODB.Connectionclass.execute错误中条件表达式中的数据类型不匹配？ [英] How to solveData type mismatch in criteria expression at ADODB.Connectionclass.execute error?

问题描述

我使用ms访问作为数据库存储数据..当我使用我的软件在32位PC上保存数据时，所有数据都成功保存而没有任何错误。但是当我在64位PC上使用相同的软件时抛出错误

System.Runtime.Interopservices.ComException（0x80040E07）ADODB.Connectionclass.execute中的条件表达式中的数据类型不匹配（string.command text.object& RecordsAffected。 Int32选项）at cmdSave_Click



我不知道为什么它在64位上产生问题...请尽快帮助我..我需要尽快回答我的客户..提前谢谢..

解决方案

嗨Rachna0309



打开你的申请在你使用的VS或VB中，然后点击''Project''，点击''Properties''然后点击''Compile''然后点击''Advanced Compile Options''

和make确定目标cpu设置为X86，如果仍然无法正常工作我会建议

点击此链接并下载两个包装并将其作为您的应用程序安装的先决条件添加或在您要运行该应用程序的计算机上安装相应的包装。



http://www.microsoft.com/en-在/ download / details.aspx？id = 13255 [

title =新窗口> ^ ]



如果这对您有用，请告诉我

I use ms access as database to store data..When I use my software to save data on 32-bit PC,all data are saved successfully without any error..But when I use the same software on 64-bit PC,it throws below error"
System.Runtime.Interopservices.ComException(0x80040E07) Data type mismatch in criteria expression at ADODB.Connectionclass.execute(string.command text.object & RecordsAffected.Int32 options) at cmdSave_Click

I dont know why its creating problem on 64-bit...Please help me as soon as possible..I need to answer my clients asap..Thanx in advance..

解决方案

Hi Rachna0309

Open your application in VS or VB which ever you use, then click ''Project'', click ''Properties'' and then click ''Compile'' then click ''Advanced Compile Options''
and make sure the target cpu is set to X86, If that still doesn''t work I would suggest
following this link and downloading both the packadges and add it as a pre-requisite to your application install or install the corresponding packadge on the machine that you want to run the application on.

http://www.microsoft.com/en-in/download/details.aspx?id=13255[
title="New Window">^]

Please let me know if this worked for you

这篇关于如何解决ADODB.Connectionclass.execute错误中条件表达式中的数据类型不匹配？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！