Not able to connect to Mysql Database using ODBC



Hi,

I am new to perl programming. Installed mysql,perl,mysql odbc drivers
in my machine. Following is my code, its not working. I googled it but
no use :(

use DBI::W32ODBC;
$dbh= DBI->connect("DBI:W32ODBC:TestMyDSN","rootuser","rootuserpwd") ||
die "Got error $DBI::errstr when connecting to $dsn\n";

error msg:
Error connecting to DBI:W32ODBC:TestMyDSN;UID=rootuser;PWD=rootuserpwd:
[911] []
"[Microsoft][ODBC Driver Manager] Data source name not found and no
default dri
ver specified"
Got error when connecting to

is there any thing missing in my machine? Any idea?

Thanks in advance.

Thanks & Regards,
Sri