in reply to changing database with DBI and DBD-ODBC
Another way is to create a 'File DSN' as a starting template. Join all the lines with ";" instead of newlines and use that as the DBI DSN. Find where the database is specified in the string, and change that as desired.
In Section
Seekers of Perl Wisdom