, I was hoping to be able to put some input into this thread, especially when I saw the question 'how do you close a connection' but, as others have quite rightly said you dont need to specifically close a connection, the connection will close after all the query processing is through, and if you do close a connection you need to specify which connection you want to close...