Maintain 1 connection is my preferred way. Opening and closing connections only when needed can really slow down performance. Create the connection when your app starts then close it when your app quits.

>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