>For some reason after I receive my cursor from the back end and do a copy to (before disconnecting) I lose my connection. Any ideas where the problem may lie? I only lose it after the copy to statement. I'm gunna try and disconnect before to the copy to and see what happens.
Is the connection being dropped because of an error or timeout? If you're hitting MS SQL Server, check the error log. Any error with a severity of 19+ will cause the connection to be killed. Also, the connection could be timing out.
-Mike