ADO API ODBC Alternative help
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
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
RE: ADO API ODBC Alternative help
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
Re: ADO API ODBC Alternative help
Hi! Check the MySQL with ASP Forum at www.dwam.net/mysql/ in particular a thread called Multiple Step Error You can also find working ADO code samples on the site (using AddNew method) Finally you should consider using the latest MyODBC drivers 2.50.39 if you want to stick to 2.xx version 3.51.02 recommended for ADO support / D W A M W 3 S P A C E / Guillaume de Lafontaine - [EMAIL PROTECTED] . Services Internet : http://www.w3space.com . Annuaire Aquitaine : http://www.aquitanet.com . Espace TeleTravail : http://www.w3workers.com . DWAM.NT Docs Resources : http://www.dwam.net -Message d'origine- De : Kelvin Lam [EMAIL PROTECTED] À : [EMAIL PROTECTED] [EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED] Date : mercredi 13 mars 2002 23:13 Objet : ADO API ODBC Alternative help |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 | | | |- |Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before |posting. To request this thread, e-mail [EMAIL PROTECTED] | |To unsubscribe, send a message to the address shown in the |List-Unsubscribe header of this message. If you cannot see it, |e-mail [EMAIL PROTECTED] instead. | - 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
Re: ADO API ODBC Alternative help
- 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. If you (or any one else) finds what causes this could you please tell me, I have just the same problem with our interbase driver, but I can't for the life of me see what the problem is. It works to SQL Server, but not Interbase. For what its worth Microsofts Access ODBC driver also generates this error, so we are not alone. Nick Gorham - 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
RE: ADO API ODBC Alternative help
Hi ! -Original Message- From: Nick Gorham [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 5:02 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: ADO API ODBC Alternative help - 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. If you (or any one else) finds what causes this could you please tell me, I have just the same problem with our interbase driver, but I can't for the life of me see what the problem is. It works to SQL Server, but not Interbase. For what its worth Microsofts Access ODBC driver also generates this error, so we are not alone. Check the online MyODBC faq, which has a working ADO code with AddNew and Update methods. http://www.mysql.com/products/myodbc/faq.html#SAMPLE_-_VB Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - 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
RE: ADO API ODBC Alternative help
the problem is doing an Update after you've done one Update without doing a MoveForward or MovePrevious. It's an ADO issue, check the KB article I posted earlier on this topic, it explains the causes and the API versions that have it. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q294160 -Original Message- From: Nick Gorham [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 8:02 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: ADO API ODBC Alternative help - 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. If you (or any one else) finds what causes this could you please tell me, I have just the same problem with our interbase driver, but I can't for the life of me see what the problem is. It works to SQL Server, but not Interbase. For what its worth Microsofts Access ODBC driver also generates this error, so we are not alone. Nick Gorham - 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