in reply to Two ODBC Connections
In keeping with a good Perl programming style
Since you are showing concerns on this matter, take a look a perlstyle - Perl style guide
Answering your question, my preference would be to give descriptive names to the connections instead of $connection and connection2.
In Section
Seekers of Perl Wisdom