Perl DBI

Some common Unicode problems and solutions demonstrated with Perl DBD::ODBC and Microsoft SQL Server

ODBC and Unicode. Inserting and selecting Unicode data.

Debugging Perl DBI

Avoid errors by following our Perl DBI best practices. Track down errors quickly by selectively logging your application's DBI activity with DBIx::Log4perl.

Using Perl DBI to publish your data on the web

This tutorial provides example CGI scripts written in Perl that display the contents of a database table in an HTML page. The tutorial also describes how to separate HTML from database data by using the HTML::Template module. Finally, it shows you how to dynamically alter a SQL query based on values supplied from a URL or a form input box.

Enabling ODBC support in Perl with Perl DBI and DBD::ODBC

This document describes how to build Perl DBI, add the DBD::ODBC module and use an ODBC driver provided by Easysoft in your Perl scripts. It shows you how to quickly add ODBC support to your Perl applications.

Perl DBI DBD::ODBC tutorial: Drivers, data sources, and connection

This tutorial describes the ODBC data sources that let you access your databases and shows you how to connect to a database from a Perl script.

Retrieving data with Perl DBI DBD::ODBC

Read this tutorial for example Perl scripts that show you how to execute a SQL statement, fetch, and display the results. The tutorial discusses the performance advantages of using parameters in prepared SQL statements. It also describes the various methods Perl DBI provides for retrieving data.

Connecting Perl on UNIX or Linux to Microsoft SQL Server

Connect Perl with SQL Server 7–2022 and Express.

Multiple Active Statements (MAS) and DBD::ODBC

How to achieve Multiple Active Statements (MAS) support without resorting to multiple connections. Includes code samples.

Perl resources

Perl web sites and mailing lists, including the site where you can download the DBI and DBD::ODBC modules.