为什么在MS Access DB中使用时出现此错误 [英] why am getting this error while am using in MS Access DB

问题描述

大家好，

我的查询在查询设计(两个Sql& MS Access)中成功执行，但是在asp.net应用程序中出现以下错误....
IErrorInfo.GetDescription失败，出现E_FAIL(0x80004005)

我的查询是:

Hi everyone,

My query executing successfully in query design (Both Sql & MS Access) but in asp.net application the following error coming....
IErrorInfo.GetDescription failed with E_FAIL(0x80004005)

my query is:

select 
[e.stdregisterno] as RegNo, 
[e.stdname] as Name, 
[e.stdsection] as Section, 
[e.bookno] as BookNo, 
FORMAT([e.stdbookretdate],'dd/mm/yyyy')as Ret_Date, 
FORMAT([e.bookdate],'dd/mm/yyyy')as BookDate, 
[e.rackname] as Rack, 
[f.partyname] as Party, 
[f.address3] as Address 
FROM [Tbl_sc_bookissue] e, [Tbl_com_schoolprofile] f 
WHERE e.compid=f.compid 
AND [e.Bissueflag]='I' 
AND [e.stdname]='" + DropDownList3.Text + "'

推荐答案

使用一些示例输入在访问中运行SQL查询，并检查您的SQL是否正常工作，
然后用过滤器参数"来解决问题

Run your SQL query in access with some sample inputs and check if your SQL is working,
then trouble shoot with Filter Paramters

我认为日期部分是该词的保留字.更改该单词，然后改用其他名称.

I Think date Section is the reserve word for that . change that word give the other name and try that..

您在查询中使用了保留关键字....

名称和部分是MS Access中的保留键，因此请将其更改为名称"/[名称]，部分"/[部分]

要查看所有保留的密钥列表，请检查: http://support.microsoft.com/kb/286335 [ ^ ]

You are using reserved keywords in your query....

Name and Section are reserved keyes in MS Access so change it to ''Name'' / [Name], ''Section'' / [Section]

To see all reserved key list please check : http://support.microsoft.com/kb/286335[^]

这篇关于为什么在MS Access DB中使用时出现此错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！