[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: ADO API & ODBC Alternative help
From:       webmaster () w3space ! com
Date:       2002-03-14 0:21:17
[Download RAW message or body]

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 - webmaster@w3space.com
. 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 <klam@otc.net>
À : mysql@lists.mysql.com <mysql@lists.mysql.com>; myodbc@lists.mysql.com <myodbc@lists.mysql.com>
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 myodbc-thread5138@lists.mysql.com
|
|To unsubscribe, send a message to the address shown in the
|List-Unsubscribe header of this message. If you cannot see it,
|e-mail myodbc-unsubscribe@lists.mysql.com 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 <mysql-thread102894@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-mysql=progressive-comp.com@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[prev in list] [next in list] [prev in thread] [next in thread]