Table of Contents
What does ODBC stand for?
History of ODBC
A very brief history of ODBC.
Who is responsible for ODBC
What organizations came up with the standard?
Intro to ODBC models
What are the ODBC model?
The ODBC first Tier.
The ODBC second Tier.
The ODBC third Tier.
Data Source Names
What are DSN's?
DSN: User vs. System
What are the differences between User and System DSN's?
ODBC Escape Sequences
What are escape sequences?
Escape Sequences 2
The Outer Join.
The Scalar Function.
Escape Sequences 5
Date and Time stamps.
Why use Win32::ODBC?
Reasons why one should consider using the extension.
Alternatives to Win32::ODBC
Other options for ODBC access via Perl.
How to Install Win32::ODBC
Instructions on installing the extension.
Using Win32::ODBC in your Perl scripts.
How to load the extention.
How to use Win32::ODBC
A basic flow diagram.
Connecting to a Database
Creating a connection object.
Connecting to a Database 2
Testing for success with your connection.
Submitting a Query
How to submit your SQL to the database.
Processing the Results
How to retrieve you data on e row at a time.
Processing the Results 2
Extracting data with DataHash().
Closing the Database Connection
How to correctly close the database.
How to retrieve error information.
Processing Errors 2
How to retrieve the last error for the extension (not just a particular
Processing Errors 3
The Error() method returns either a scalar or a string.
Processing Errors 4
How to interpret the results of Error().
Win32::ODBC in a CGI script
Hints on how to use Win32::ODBC in a CGI script.
Things to look out for when using Win32::ODBC.
Common Gotcha's 2
How to determine the text delimiter for a particular ODBC driver.
Common Gotcha's 3
A note about constants.
A note about the Win32::ODBC namespace.
How to find more information on Win32::ODBC.
Home Page: http://www.roth.net/
Perl and ODBC This presentation is the HTML version
of Dave Roth's presentation given on Aug. 20, 1997 at the First Annual
Perl Conference, hosted by O'Reilly & Associates.
This page has been visited
times since September 15, 1997.
presentation file (in MS PowerPoint 97 format)