February 2000
Intermediate to advanced
364 pages
11h 47m
English
Content preview from Programming the Perl DBI
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 7. ODBC and the DBI
Open Database Connectivity, commonly known as ODBC , defines a database-independent API. The ODBC Driver Manager supports the API and manages one or more plug-in drivers for talking to different types of databases. The architecture is shown in Figure 7.1.
 |
Figure 7-1. The ODBC architecture
Doesn’t this all sound rather familiar? The ODBC driver manager and drivers are doing just what the DBI and its drivers are doing: defining and implementing a database-independent, application-programming interface.
This leads us to a whole bunch of questions: What’s the difference? Why not just use ODBC and not the DBI? Can the DBI and ODBC work together? What advantages does one have over the other?
Before we try to answer those questions, let’s get some
perspective by looking into the history and goals of ODBC and the
DBI, and take a look at the Win32::ODBC module,
which implements a direct interface to ODBC for Perl.