I want to create a class that handle the remote connection to SQL Server 2000. I was wondering what could be better whether to maintain one connection open and do all the procees or open a new connection when need it and the close it?

Regards,

Reinaldo Sanchez