use warnings;
use strict;
use DBI;

my $dsn="XYZ";
my $user="XXXX";
my $password="XXXX";

my $dbh=DBI->connect("dbi:ODBC:$dsn", $user, $password,
                      { RaiseError => 1, AutoCommit => 0 });

my $query = "INSERT INTO temp (SNO, Name, Institute) VALUES (5,'Ram','IIT')";
my $query_handle = $dbh->prepare($query);

$query_handle->execute();