Table of Contents
Welcome
An Introduction.
ODBC
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?
Model 1
The ODBC first Tier.
Model 2
The ODBC second Tier.
Model 3
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.
Escape
Sequences 3
The Scalar Function.
Escape
Sequences 4
Stored Procedures.
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.
Loading Win32::ODBC
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.
Processing Errors
How to retrieve error information.
Processing Errors 2
How to retrieve the last error for the extension (not just a particular
database connection).
Processing Errors 3
The Error() method returns either a scalar or a string.
Processing Errors 4
How to interpret the results of Error().
Misc details
Using
Win32::ODBC in a CGI script
Hints on how to use Win32::ODBC in a CGI script.
Common Gotcha's
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 Shortcut
A note about the Win32::ODBC namespace.
More Information
How to find more information on Win32::ODBC. |
Author:
Dave Roth
Email: rothd@roth.net
Home Page: http://www.roth.net/
Other information:
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.
Download
presentation file (in MS PowerPoint 97 format) |
