Okay. For your above script, put some error checking into it so you can
see where the failure is taking place.
#!/usr/bin/perl -w
use strict;
my $filename = "File_Name_One";
my $letter = "A";
my $dbh = DBI->connect("DBI:ODBC:databasename", "","")
|| die "error: ($DBI::errstr)\n";
my $firstvar = $dbh->quote($filename);
my $secondvar = $dbh->quote($letter);
my $statement = "Insert into tableOne (filename, letter)
values ($firstname, $letter)";
# Now you need to actually execute the statement
$dbh->do( $statment ) || die "error: $dbh->errstr\n";
# rest of code
-derby |