cannot update data base - error in row (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

winter -> cannot update data base - error in row (3/12/2002 22:26:23)

Hi, Its been a while since I have visited the forum, but I am back on a new learning curve - data bases. I hope someone can help... would really appreciate some light on this mystery.

I have 7 pages with forms each with the same form fields accept for one which contains key words in a drop down boxy pertinent to that page of data. They all go to the same data base, but I think I am making a mistake in how I save the form properties. It does seem like frontpage is creating a table for the results of each page, naming it the title of the page.

Going into connect to data base option..It has created data base connection1 and I browse another box and get the path to the data base named something else. Set the web settings with verify and publish. Verify again once online.

The forms work fine initially but after 2 or 3 trys give the message:

"Cannot update the database
Error Description: [Microsoft][ODBC Microsoft Access Driver]Error in row
Error Number: -2147217873
Error Source: Microsoft OLE DB Provider for ODBC Drivers"

I cannot find the error number at microsoft and the web host tech staff said it might have to do with setting a primary key.

Also, these forms are in a subweb, and the data base file is in the fpdb folder for the sub web. On the direction of the server technician I moved the copy of the data base at the root level to a folder labelled DATA. It looks to me like the data goes to one are in the subweb but not the root web. Is that how its suppose to work?

I have all but demolished the database I set up... any ideas on how to fix this or where to read?

Thanks ever so much.




"All that matters is what we do for each other" Lewis Carroll



winter -> RE: cannot update data base - error in row (3/13/2002 12:24:09)

Well... I did some more searching and actually found the error number in this forum experienced by someone else on March 15 2001... but it still seems unrelated to the problem I am experiencing. In a burst of inspiration I did go into Access and made sure there was a table for results ( I had deleted it) and a table with primary keys for each form.

If anyone would like to take a look...Links to all of the seven pages are found on the right-hand side of this page:
http://www.lighttravels.com/MasteringThePresentMomentProject/Submit.htm

One of the seven pages with the form is found at:
http://www.lighttravels.com/MasteringThePresentMomentProject/Submit%20Pages/waters.asp

Could this problem be related to that dialog boxy that asked for the fields to be mapped? In that case there is another mystery. There are 3 fields to map and an additional mapping option - the name of the page. So I selected the name of the page to map to key word since that is the only thing that distinguishes the pages.

Problem still not fixed.

Well... any other ideas?

Thanks so much.

W

"All that matters is what we do for each other" Lewis Carroll



winter -> RE: cannot update data base - error in row (3/13/2002 17:42:10)

GOOD NEWS! & I share this in case anyone else has this problem and ask that anyone who actually knows what they are doing to please correct this IF I am wrong...here is what I discovered that works:

Each form set up by FP2K, collectiong the same info for (lets say this project) except one thing different on each page ( in this case a drop down menu of key words) must connect to its own data base! It looks to me like multiple forms generated by FP can't go to the same data base unless they have different fields.

Well...lets just say it worked. The new server company I just switched to tells me I can have as many databases as I want with FP until my 100 meg of space runs out.

I think just hanging out at his forum is good energy and plugging into the consciousness of this learning community sparked the answer. Do you have avatars for this? LOL

Please let me know if I am leading others astray. THanks!

"All that matters is what we do for each other" Lewis Carroll



Spooky -> RE: cannot update data base - error in row (3/14/2002 3:13:09)

FP does set up a seperate database for each form, so you would need to redirect all of the data source names to the correct data if you wanted the one database. May be messy but worth it :)

§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login



bongle -> RE: cannot update data base - error in row (1/7/2004 14:42:40)

Seeing as this thread comes up pretty high when searching on google for "error in row", here's my non-frontpage solution.

The error occurs when my ASP script calls <myRecordsetName>.update(), after calling <myRecordsetName>.addnew, and setting some fields. As it turns out, the reason mine was failing was because I was I was trying set one of the fields against that field's validation rules. I had an ID field that was set to no duplicates, and I was setting a duplicate value. So, I fixed that code, and everything was fine.



Russ_ -> RE: cannot update data base - error in row (3/27/2008 6:39:44)

I had this prob when updating a link table. Turned out the foreign keys were illegal entries. My tip: Enter the values direct in the database to see if your process will work on the database level



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
4.882813E-02