ok here's what I have:

1) installed iODBC
iODBC.ini looks like this:
--------------------------------------------------------------------------
[ODBC Data Sources]
SQLServer_Ape_Test=DataDirect 4.0 SQL Server Wire Protocol

[SQLServer_Ape_Test]
Driver=/path/to/lib/libiodbc.so
Description=SQLServer_Wire_Protocol
Database=mydbname
Address=fqdn.to.server
Port=port#

[Default]
Driver=/path/to/lib/libtdsodbc.so
-------------------------------------------------------------------------------

2) installed FreeTDS
modified the freetds.ini file to include the following:
------------------------------------------------------------------------------
[SQLServer_Ape_Test]
host = fqdn.to.server
port = port#
tds version = 4.2
--------------------------------------------------------------------------------

3) now my perl/dbi script:
-------------------------------------------------------------
#!/usr/bin/perl -w

use DBI;

$dbh=DBI->connect(
"dbi:ODBCQLServer_Ape_Test",
'myusername', 'mypassword',
{RaiseError => 1,
PrintError => 1
}
) || die("Database connection not made: $DBI::errstr");
$sth=$dbh->prepare('
select count(*) from dbo.tblWorkUnitProgress
');
$sth->execute;
$dbh->disconnect;
-------------------------------------------------------------------------------

When I run the script, I get no errors but the script just hangs. Where did I mess up??