?
Solved

SQL Web Assistant: Web task not found!!!

Posted on 2003-03-29
6
Medium Priority
?
614 Views
Last Modified: 2012-06-21
Hi,
I cant solve the problem:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]SQL Web Assistant: Web task not found. Verify the name of the task for possible errors.

This is happenin continously when I try to call a stored procedure or execute some T-SQL commands on my ASP page.
Thanks.
0
Comment
Question by:rizamasirov
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 1

Expert Comment

by:JWT
ID: 8230661
Are you using sp_runwebtask?  or perhaps the SQL Web Assistant?

Can you post the ASP code in the proc call?

My first instinct would be to look at the sproc name to make sure it is spelled correctly.  Also check your permissions.  The user must have SELECT permission on the sproc to run it.

In general, I would reccomend using ADO for sproc calls from ASP pages.

Good Luck
0
 

Author Comment

by:rizamasirov
ID: 8230808
It doesnt differ from useing sproc or T-SQL. For example:

Line 41 : conn.execute("UPDATE kayitlar SET title='"&title(I)&"',descr='"&descr(I)&"',createdate='"&CrDate&"',secret_status='"&secret_status(I)&"' WHERE id = '"&Cint(PID_Checked(I))&"'")

-----------------------------------------------

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]SQL Web Assistant: Web task not found. Verify the name of the task for possible errors.

/album/Kmasterupdate.asp, line 41


I have no idea about "sp_runwebtask" or "SQL Web Assistant". How can I check it out?
Thanks
0
 
LVL 1

Expert Comment

by:JWT
ID: 8230933
If you are not using "sp_runwebtask" or "SQL Web Assistant" don't worry about it.  It looks like you are using ADO.

OK - so I didn't think this would be an easy solution.

Try this - does the table kayitlar have any triggers on it?

To view the triggers on a table use

sp_helptrigger 'tablename'

If so that trigger may reference an old trigger, or the trigger name may be mispelled.

Also - try running your query in Query Analyzer directly against the database.
0
Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

 

Author Comment

by:rizamasirov
ID: 8230975
Triggers:
------------------------------------------
life Web Page_1 dbo     0     0     1    
life Web Page_2 dbo     1     0     0    
life Web Page_4 dbo     0     1     0    
------------------------------------------

I dont know how I did this  :(((
How can I drop all triggers? Because I dont know how to use them.

Here is the output of Query An.
-------------------------------------------
UPDATE kayitlar SET title='AA',descr='assadasd',createdate='02.02.2003',secret_status=1 WHERE id = 93
-------------------------------------------
Server: Msg 16882, Level 11, State 1, Line 0
SQL Web Assistant: Web task not found. Verify the name of the task for possible errors.

(1 row(s) affected)
-------------------------------------------
0
 
LVL 1

Accepted Solution

by:
JWT earned 200 total points
ID: 8231108
Yup it was the triggers!

Whew - I was wonderin' about this one.  Anyway, to drop them just issue a

DROP TRIGGER nameOfTriggerHere in QA.

Good Luck
0
 

Author Comment

by:rizamasirov
ID: 8231150
Thanks! Great solution! :))
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question