Having just checked my ActiveState installation I find that
ODBC.pm exists in d:\perl\site\lib\DBD

The use DBD directive will check your @INC array for a directory containing the directory DBD so
use DBD::ODBC will try to find ODBC.pm in
d:\perl\site\lib\DBD