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

List:       mysql
Subject:    Re: ADO API & ODBC Alternative help
From:       "c.smart" <clive () dev ! co ! za>
Date:       2002-03-13 22:19:59
[Download RAW message or body]

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 <mysql-thread102872@lists.mysql.com>
> To unsubscribe, e-mail <mysql-unsubscribe-clive=hardrive.co.za@lists.mysql.com>
> 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 <mysql-thread102873@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]