Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Answer: What is the difference between ADO and ODBC ?

( #327813=categorized answer: print w/ replies, xml ) Need Help??

Q&A > database programming > What is the difference between ADO and ODBC ? contributed by Anonymous Monk

From experience in writing wrappers for both and profiling both using DevPartner I can actually say that ODBC is a lot faster. You trade of ease against performance when going with ADO. Though this depends on the wrapper you write and the way you use the ODBC calls. Besides ODBC is portable between platforms and you can use it to read flat files, access files, excel files, sql server, oracle, mysql etc.

Comment on Answer: What is the difference between ADO and ODBC ?
Re: Answer: What is the difference between ADO and ODBC ?
by inman (Curate) on Feb 10, 2004 at 09:11 UTC
    ODBC has been around for a long time. The system is stable and vendor drivers have been updated and bug fixed over many versions. ODBC is a self contained API that can be installed and used on both UNIX and Windows.

    ADO is new than ODBC and arguably better designed (esp. in terms of programming interface). Being newer, the ADO drivers have been through fewer bug fix and update cycles. ADO also requires that the COM layer is instantiated. This has something of an ovehead and adds considerably to the total number of things that can go wrong with CGI apps etc. ADO is targeted at Windows.

    Not mentioned in the question but a crucial consideration for Perl developers is the DBD/DBI platform. drivers are available for ODBC and ADO data sources. Most drivers use the native database APIs.

Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (7)
As of 2014-07-12 06:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (238 votes), past polls