I am testing some applications which are written in VB with backend as SQL Server 2000. This applications runs for hours since the applications has to deal with huge text files (in GBs). they usually bulk insert these huge files into Database and then does some operations on the DB. While testing these applications i am recieving three types of Errors (Each from different application):
Run-time error '40002' S1T00:[Microsoft][ODBC SQL Server Driver]Timeout Expired
Bulk Insert Fails. Column too long. Make sure field terminator and row terminator are specified correctly. Run-time error -21472117900(80040e14)
Could not bulk insert because file 'e:\code\abc.txt' could not be opened. Operating system error code 32 (The process cannot use this file because it is being used by another process.)
These two errors are generated from two different Applications. please send me an appropraite cause of these errors.