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

List:       mysql
Subject:    RE: ADO API & ODBC Alternative help
From:       "Gregory Junker" <gjunker () shockwaveaudio ! com>
Date:       2002-03-13 22:30:04
[Download RAW message or body]

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:clive@dev.co.za]
> Sent: Wednesday, March 13, 2002 5:20 PM
> To: klam@otc.net
> Cc: mysql@lists.mysql.com; myodbc@lists.mysql.com
> 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 <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-gjunker=one.net@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-thread102875@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]