>From your point of view it's off-topic (and it is), but from his the problem could be anything, including MySQL. You did, however, produce the proper answer, since this is an ADO issue, and I further provide a link to the relevant Knowledge Base article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q294160 My suggestion to Kelvin is that you don't Update until you have set all the fields you need to set. GJ > -----Original Message----- > From: c.smart [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 13, 2002 5:20 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: ADO API & ODBC Alternative help > > > Get your VB Manuals out, or test your programme against an > Access Data Base. > Once you have issed an Update statement, you need to either > retrieve the record > for further update or set all the fields then issue the > Update statement! > > This is very 'Off Topic" > > Clive Smart > > Kelvin Lam wrote: > > > Hi, > > > > I am a beginner developer trying to use mySQL ODBC with > ADO. I am using ADO > > library version 2.5, and Visual Basic 5.0/6.0 (doesn't > really matter). > > > > Here is my configuration: > > - mySQL ODBC Version 02.50.38 > > - mySQL server Version 02.50.38 > > - Windows NT 4.0 with SP6 > > > > It seems like, mySQL does not implement all the ADO > functionality. My > > questions will be: > > 1- what is the set of functions in ADO that mySQL supports? > Can I find > > documentation about it? > > 2- If ADO is not fully supported, what other ways have > people used for > > database programming? DAO? RDO? Raw ODBC API call? > > > > Now for the specific problem I have, I have this code in VB: > > rsTest.AddNew > > rsTest.Fields("login").Value = CStr("kelvin") > > rsTest.Update > > rsTest.Fields("Password").Value = CStr("testing") > > rsTest.Update > > rsTest.Fields("Fullname").Value = CStr("my name") > > rsTest.Update > > rsTest.Fields("securitylevel").Value = 1 > > rsTest.Update > > > > - I get an adStateOpen for both connection and recordset. > > - The ADO connection opened correctly. The ADO recordset > opened correctly > > as well. > > - The AddNew executed without error. > > - The setting of "login" value executed without error. > > - When I hit the line setting value of "password", I get > the following > > message: > > Run-time error '-2147217887 (80040e21)': > > Multiple-step operation generated errors. Check each status value. > > > > What did I do wrong? > > > > Kelvin Lam > > Software Engineer > > Orbit Technology Corp > > 1528 Brookhollow Dr, Suite 66 > > Santa Ana, CA 92705 > > Phone: (714)427-0555 > > Fax: (714)427-0556 > > > > > --------------------------------------------------------------------- > > 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 > > --------------------------------------------------------------------- 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
