I have had very much success with passing sql commands via ado over the
myodbc layer. I wouldn't trust addnew and update batch methods nor have I
tested how or if they work, it's better to keep your connections to the
database stateless for performance purposes. Meaning to execute dml
statements use the ado connection object to establish the connection and
pass your sql command to the db, then close your connection. Get in, get
out. Don't hold anything open as your looping thru your rs... imho
Same with retrieving recordsets, I recommend using disconnected recordsets
which work terrific. Make your connection, pass your select, get your rs
back, close your connection and manipulate your new disconn rs object using
the full scope of adodb.rs methods & props.
hth
chris
www.mydba2000.com
>From: "Kelvin Lam" <[EMAIL PROTECTED]>
>Reply-To: <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: ADO API support?
>Date: Tue, 19 Mar 2002 17:43:56 -0800
>
>Hi,
>
>I tried to read the documentation, but there are only examples instead of
>specific/explicit documentation
>My question is-which ADO objects/methods/properties does myODBC support? I
>can easily found the entire ADO programming model, all the objects, and
>their methods/properties in MSDN.
>But, I haven't been able to found the same quality work on myODBC
>documentation (or am I blind?)
>For example, not until I try it out, I realized, as posted in newsgroup,
>that the UpdateBatch is not support in myODBC.
>Please advise.
>I am using the stable release 2.50.
>If people had better experience and performance with newer version, please
>let me know.
>Any pointer would be greatly appreciated!
>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 [EMAIL PROTECTED]
>To unsubscribe, send a message to the address shown in the List-Unsubscribe
>header of this message. If you cannot see it, e-mail
>[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
---------------------------------------------------------------------
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
