Roth Consulting


Roth Consulting

Perl and ODBC

Last updated 97.10.16

Click here to start the presentation

Table of Contents

An Introduction. 

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  


Home Page:   

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 Count times since September 15, 1997.  

Download presentation file (in MS PowerPoint 97 format)