Use SQLSTRINGCONNECT. You don't need to setup a DSN and you can create as many connection handle as you like. Just store each one to an application property or public variable.

Charlie