Click here to Skip to main content
15,891,905 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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:
SQL
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 + "'
Posted
Updated 25-Jul-12 4:38am
v3

Run your SQL query in access with some sample inputs and check if your SQL is working,
then trouble shoot with Filter Paramters
 
Share this answer
 
I Think date Section is the reserve word for that . change that word give the other name and try that..
 
Share this answer
 
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[^]
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900