Thank you. I was able to solve that problem. My socket was time based(timeout) and not databased. I had to make some correction in the code so that it recevies the data till the last byte. Sri

Amazingly enough I just googled ftp error codes and it gave me a list of all the ftp error codes. Maybe you should try.

If you are processing one record at a time, ie. 1 million customer orders, use a data reader to scan through and a forward only manner using less memory. If you are using aggregate results SQL is a powerful language designed to work on large sets of data very efficiently. Last note: if you have to work with large chucks of data in memory find a natural divider and use smaller sets. File Not Found

Yes.. :) Srinath

Do i have to impersionate the user...while accessing the data base ? Srinath