OleDbDataAdapter hangs on update

[Mary W via DotNetMonster.com]

I have an application that is reading a database table and "copying" the data
to the identical table in another database. This table contains a field of
type OLE Object (which contains image, video, etc.). I am using an
OleDbDataReader to retrieve a single record at a time from the source DB. I
copy the retrieved values to a DataSet and then use an OleDbDataAdapter to
insert the new row into the destination DB. This appears to work fine "most
of the time"; however, the application will occasionaly hang on the
dataadapter.UPDATE. No error is given and the application does not respond
to an end request from the windows task manager (Windows XP) -- I have to end
the process.


Any ideas?

Mary

 

[Guest]

If the amount of data in the binary field is very large, you might be
experiencing some form of timeout problem.

If you leave the application, does it eventually recover or produce an
actual exception? If so, can you wrap the update with a specific exception
handler (E.g. SQLException) and have a look at the detailed exception message?

Also, you might be better off with some form of server-side solution to
improve the performance. Obviously, this is not always possible or adviseable
however it would certainly provide better performance than loading it into
memory on a client and then resubmitting the information back to the server
or different server etc.

Hope this helps,

-Eric