I have it connecting to the database like this:
use DBI;
use DBD::ODBC;
my $conn_string = "driver={SQL Server};Server=SERVER NAME;Database=DB
+NAME";
my $dbh = DBI->connect( "DBI:ODBC:$conn_string" ) or die $DBI::errstr;
# get each SKU
my ($sth, $stmt );
my $count=0;
$stmt = qq { select sku
from TABLE NAME
};
$sth = $dbh->prepare ($stmt);
$sth->execute ();
I believe this is working, because I did a trial run of it. Do you have a suggestion as to where I can look up how to write a hash? Thank you for all your help!