I am using ADO and SQL server 2000 and I was wondering, is it better to open a global connection and then use that one when needed or to create and open a connection locally just when needed(this is what i am doing now). Thanks