I've encountered this before. Several of my clients use mySQL and most of
them Linux, however my servers that run mySQL all are W2k. The issue
happened like you said when migrating data from w2k to linux. It was a few
versions ago in 3.22 however, but the auto-increment field didn't translate
for some reason, and so when people inserted records on the linux-mysql
version of the db, it didn't auto-increment in the field it was supposed to.
The error would happen when I would call the data/update it, and it would
look for the field with the auto-increment data, and lo- it was not there
hence the error. Check to make sure any auto-increment data is inserting
like it should.
my (2cents(US)) (2.5 cents(UK)) (.9 cents(CA)) (God only know how many
pesos, rubbles, yen, or euros)
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-----Original Message-----
From: David S. Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 1:06 PM
To: [EMAIL PROTECTED]
Subject: problem updating recordset with MyODBC
When I try and update a recordset I get the following problem-
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Query based update failed. The row to update could not be found.
/Part1_Section1_Process.asp, line 82
Line 82 happens to be when I call rs.Update()
The problem only occurs when I update certain records. Other records have
no problems. Before I had no problems (all records were fine
updating). Then I migrated my tables from Win2000 mySQL to a mySQL running
on Linux. That is when I noticed that it would not update in some
cases. It isn't clear why some records give me problems and others do not.
What makes it frustrating is that there seems to be no obvious cause of
problem. The code has not been altered one bit. If I move back to Win2000
I'm sure it will work again. But I really want this to work consistently
for our Linux DB server.
Has anybody seen anything like this before. Can anybody help?
David
--------------------------------------------------------------
David Green
Northwestern University, Evanston, IL USA
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
