when i enter a new record into the database then an error has come
"[microsoft][ODBD SQL server driver][SQL server]SQL web assistent:
web task not found.varify the name of the task for possible error"

I'm wroking in vb6.so what is the problem and solution.

vicky

__________________
vicky

Have you check all the field mentioned in the INSERT command and the respective values are given.

Any p.key/ref. field value is not validated/set properly.

can u post the part of your code to be helpful to check for the Driver info...

I tried it at my level best,but i can't find the error.so I'm posting u my code.
rs1!ent_date = Textentdate.Text & ""
                rs1!sno = val(Textsno.Text) & ""
                rs1!batch = val(Combobatch.Text) & ""
                rs1!semi = UCase(Combosemi.Text) & ""
                rs1!name = UCase(textname.Text) & ""
                rs1!disci = UCase(Combodisci.Text) & ""
                rs1!inst_code = comboinstcode.Text & ""
                rs1!add_inst1 = UCase(Comboinstname.Text) & ""
                rs1!sd = Textsd.Text & ""
                rs1!dura = val(Textdura.Text) & ""
                rs1!ed = Texted.Text & ""
                rs1!sem_1 = val(no(0).Text) & ""
                rs1!sem_2 = val(no(1).Text) & ""
                rs1!sem_3 = val(no(2).Text) & ""
                rs1!sem_4 = val(no(3).Text) & ""
                rs1!sem_5 = val(no(4).Text) & ""
                rs1!sem_6 = val(no(5).Text) & ""
                rs1!sem_7 = val(no(6).Text) & ""
                rs1!sem_8 = val(no(7).Text) & ""
                rs1!pers = val(Textpers.Text) & ""
                rs1!selected = UCase(Comboselected.Text) & ""
                rs1!joined = UCase(Combojoined.Text) & ""
                rs1!recomm = UCase(Textrecomm.Text) & ""
                rs1!stipend = UCase(Combostipend.Text) & ""
                rs1!sti = val(Textamount.Text) & ""
                rs1!os1 = UCase(Comboos1.Text) & ""
                rs1!os2 = UCase(Comboos2.Text) & ""
                rs1!os3 = UCase(Comboos3.Text) & ""
                rs1!db1 = UCase(Combodb1.Text) & ""
                rs1!db2 = UCase(Combodb2.Text) & ""
                rs1!db3 = UCase(Combodb3.Text) & ""
                rs1!lang1 = UCase(Combolg1.Text) & ""
                rs1!lang2 = UCase(Combolg2.Text) & ""
                rs1!lang3 = UCase(Combolg3.Text) & ""
                rs1!course_cat = UCase(Combostatus.Text) & ""
                rs1!category = UCase(Combocategory.Text) & ""
                rs1!nic = UCase(Combonic.Text) & ""
                rs1!per_add1 = UCase(Textadd1.Text) & ""
                rs1!per_add2 = UCase(Textadd2.Text) & ""
                rs1.Update
                rs1.Requery

it is the code for save the updation .SNO is primary key.

vicky

I think you are missing the single quotes around the values for columns that are of char/varchar/text/datetime types. I dont understand why you got to use & "" at the end of every line there. Can you explain on that?

_________________________
- Vijay G
Strive for Perfection

Do you have any web tasks running? like sp_makewebtask? maybe on of the stored procedures created by this sp_ is missing.



Sal

perhapes it is the problem of sQL server,coz when i tried to edit
the any record from Query Analyzer,then the server returns the same error as
"Server: Msg 16882, Level 11, State 1, Line 2013478264
SQL Web Assistant: Web task not found. Verify the name of the task for possible errors."
so what is the problem,i'm also run it on others systems.


vicky

If you have a task set-up with teh SP_makewebtask and you are making it fire when a record changes, this will be implemented with a triggeer. If the stored procedure to run the web task has been deleted, the trigger will fail and it may rollback your transaction. This will happen regardless of what you use to try to change the data.

Thence the question, Do you have any web tasks running on the SQL Server? Does anyone else?



Sal