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
