The source code of UpdateDBviaODBC.pl :
<![CDATA[
# To be run at a command prompt on a PC using the command:
# perl UpdateDBviaODBC.pl
# Demo of updating a database via an ODBC link.
# Author: SB Jones, June 2001
use strict ;
use DBI ;
my ($dsn, # data source name configured in the ODBC control panel
$dbh, # database handle
$sth, # statement handle
@row, # row (record)
%attr, # error-checking attributes for DBI
$ProxyID # machine, port, database
) ;
my ($season, $title) ;
$dsn = "<replace>";
$dbh = DBI->connect("dbi:ODBC:$dsn");
$sth = $dbh->prepare("INSERT INTO Panto VALUES ('Winter 1955', 'Tom Thumb')") ;
$sth->execute ;
$dbh->disconnect ;
print "That's all\n" ;
]]>