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

List:       mysql-odbc
Subject:    ADO API & ODBC Alternative help
From:       "Kelvin Lam" <klam () otc ! net>
Date:       2002-03-13 22:12:30
[Download RAW message or body]

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.

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