It is recommended to use one public connection but what if one has to connect to different databases at once? Is it okay to use two public connection objects? We separated the database for our transaction logs hence I need to have a connection object for it also...

Thanks!