Thanks for the replies. I tried calling the close method explicitly but I still had the same problem. I will try what mjsimmons suggested. Thanks again.

-AnthonyC

Thanks for the reply.

How can I make sure it's closed? The script destroys the ADO.Connection object before populating the spreadsheet.

-AnthonyC