I really like using ADO and I've had very good luck with it. I have used
it extensively to connect to access, sybase, oracle, and mysql databases as
well as other non relational data sources (using the correct provider). I
believe that the flexibility is the best part about ADO. Therefore if your
queries are fairly simple and are not taking advantage of some database
specific feature, then standardizing on ADO would enable you to move the
application more easily in the unlikely event that you outgrow MySQL.
In a nutshell:
ADO plusses: flexible and simple to code (few objects), easy to port and
support in the future
ADO minuses: Adds a layer of processing, therefor slower
API plusses: speed
API minuses: Yet another API to learn (however, it might be as easy as ADO,
I don't know)
Regards,
Gary "SuperID" Huntress
=======================================================
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
----- Original Message -----
From: "Warren van der Merwe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 05, 2001 2:25 PM
Subject: API or ADO??
> Hi again
>
> database, sql
>
> Should one rather use ADO or the API for Windows programming? I am in a
> situation at the moment and don't know which one to move forward with. My
> program is currently developed with ADO, so that seems a slightly more
> 'easy' route to go, except that some ADO features don't seem to be
supported
> properly and so all I am really using ADO for at the moment is to view
> records, the API give me this same functionality, except some other things
> would need to be changed to work with the API.
>
> So, with the above, my question is more in terms of speed and reliability.
> Which would be better?
>
> Kind regards
> Warren
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Warren van der Merwe
> Software Director
> PRT Trading (Pty) Ltd t/a RedTie
> Durban, South Africa
> Cell (+27-83) 262-9163
> Office (+27-31) 767-0249
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
