>As a last resort, we can have the COM objects create the connection each time it is needed, however we didn't want have to constantly create and drop connections to SQL server.

I wouldn't worry about it. It's a common practice and connection pooling should negate the performance hit as long as you're using a constant login.

-Mike