A DBI data source starts with "dbi:" followed by the driver name. Everything after that (in the same string) is passed to the driver itself.
So what you need is something like
DBI->connect("dbi:ADO:$dsn", $user, $passwd)
where $dsn is a valid ADO connection string.
The DBD::ADO documentation references
http://www.able-consulting.com/ADO_Conn.htm#DSN as a source of documentation on constructing ADO connection strings. There are several examples there.
Note that I have never used DBD::ADO; all of this was gleaned from reading the documentation.
Impossible Robot