•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 402,063 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,501 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP advertiser: Lunarpages ASP Web Hosting
Views: 2093 | Replies: 2
 |
•
•
Join Date: Dec 2007
Posts: 4
Reputation: 
Rep Power: 0
Solved Threads: 1
Newbie Poster
ASP and MSSQL : Microsoft OLE DB Provider for ODBC Drivers error '80040e14' Hi All,
I have a software module(enquiry) developed in ASP using MSSQL as back end.
In the index page , i display 4 new enquiries for the logged in user, clicking on which land to the enquiry pages. This has been working fine. But now recently i have come across the following error.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The query has been canceled because the estimated cost of this query (353) exceeds the configured threshold of 300. Contact the system administrator.
Can anyone tell me as to why i am getting this error.
regards,
nikie
I have a software module(enquiry) developed in ASP using MSSQL as back end.
In the index page , i display 4 new enquiries for the logged in user, clicking on which land to the enquiry pages. This has been working fine. But now recently i have come across the following error.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The query has been canceled because the estimated cost of this query (353) exceeds the configured threshold of 300. Contact the system administrator.
Can anyone tell me as to why i am getting this error.
regards,
nikie
•
•
Join Date: Sep 2004
Location: Plymouth, UK
Posts: 79
Reputation:
Rep Power: 4
Solved Threads: 1
Junior Poster in Training
As your SQL server is configured to run any query which will be executed with in 300ms. And now in your case, your query's estimated execution time is 353 which is more than the time set by the DB administrator.
So either you will need to optimise the query to be executed in lesser time or you should optimise the database tables to return your desired data in less time.
If you could give more details about the query then I might be able to tell you exactly whats going wrong.
So either you will need to optimise the query to be executed in lesser time or you should optimise the database tables to return your desired data in less time.
If you could give more details about the query then I might be able to tell you exactly whats going wrong.
•
•
Join Date: Dec 2007
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
hi,
Thankyou for the response!
The error i am receiving is the following
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The query has been canceled because the estimated cost of this query (335) exceeds the configured threshold of 300. Contact the system administrator.
/index.asp, line 65
and line 65 is highlighted below
Set Lead_Rec = Server.CreateObject("ADODB.Recordset")
Lead_Rec.Cursorlocation = adUseClient
Lead_Sql = "select * from g_leads,g_client,g_enquiry where (g_leads.client_id=g_client.client_id) and (g_leads.lead_id = g_enquiry.lead_id) and (g_client.user_id=" & objLu.Id & ") and (g_leads.lead_status=1) order by g_leads.lead_id desc"
Lead_Rec.open Lead_Sql,Application(db),adOpenForwardOnly,adLockReadOnly
L_R_Count = Lead_Rec.RecordCount
Actually old users have a lot of enquires and i have to display all their old enquiries right from 2004.I guess the data is really large.
Could you tell me as to how i can increase the query execution time?
regards,
nikie
Thankyou for the response!
The error i am receiving is the following
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The query has been canceled because the estimated cost of this query (335) exceeds the configured threshold of 300. Contact the system administrator.
/index.asp, line 65
and line 65 is highlighted below
Set Lead_Rec = Server.CreateObject("ADODB.Recordset")
Lead_Rec.Cursorlocation = adUseClient
Lead_Sql = "select * from g_leads,g_client,g_enquiry where (g_leads.client_id=g_client.client_id) and (g_leads.lead_id = g_enquiry.lead_id) and (g_client.user_id=" & objLu.Id & ") and (g_leads.lead_status=1) order by g_leads.lead_id desc"
Lead_Rec.open Lead_Sql,Application(db),adOpenForwardOnly,adLockReadOnly
L_R_Count = Lead_Rec.RecordCount
Actually old users have a lot of enquires and i have to display all their old enquiries right from 2004.I guess the data is really large.
Could you tell me as to how i can increase the query execution time?
regards,
nikie
|
•
•
•
•
•
•
•
•
DaniWeb ASP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
ajax antivirus apple asp business c# computer console development drm exploit firefox game google internet ip ipod linux malware microsoft mobile mozilla mp3 news novell office open operating os pc red hat search security serial software source spyware survey system ubuntu upgrade virus vista web windows xbox 360 xml xp yahoo zune
- Previous Thread: ASP Page Template
- Next Thread: I need examples of website admin pages in asp
