getting timeout expired error

[venu656]

Hi. experts... iam using bulk copy to copy l lac of records from one table to another table which was in a different servers ... when code goes evrey thing fine .... it was getting timeout error .... i checked for 10 thousand rows it was working fine.......... even i incresed the max pool size plz find the solution.........

[musefan]

venu656 wrote:

plz find the solution

er.... No.... THNX

Life goes very fast. Tomorrow, today is already yesterday.

[MumbleB]

venu656 wrote:

when code goes evrey thing fine .... it was getting timeout error

Don't know what this means. Is it going ok? Can you post block of your code? Is the timeout on the server it is copying to?

Excellence is doing ordinary things extraordinarily well.

[Dave Kreskowiak]

Copy them in smaller blocks of records instead of all at once.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008
But no longer in 2009...

[BillWoodruff]

1 lac means one-hundred-thousand. From the Sanskrit lakshaya : most often transliterated into English as "lakh." best, Bill

"Many : not conversant with mathematical studies, imagine that because it [the Analytical Engine] is to give results in numerical notation, its processes must consequently be arithmetical, numerical, rather than algebraical and analytical. This is an error. The engine can arrange and combine numerical quantities as if they were letters or any other general symbols; and it fact it might bring out its results in algebraical notation, were provisions made accordingly." Ada, Countess Lovelace, 1844