SQL Web Assistant: Web task not found!!!

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.
rizamasirovAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JWTCommented:
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
rizamasirovAuthor Commented:
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
JWTCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

rizamasirovAuthor Commented:
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
JWTCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rizamasirovAuthor Commented:
Thanks! Great solution! :))
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.