Roth Consulting

Presents

Roth Consulting
 

Perl and ODBC

Last updated 97.10.16

Click here to start the presentation

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

Download presentation file (in MS PowerPoint 97 format)