i tried setting timeout for connectiona and command object but still
it is not working

i tried with some other sp which doesn't have temp table it works fine

but when i try executing the sp which has some temp table it gives me
automation error

anbu.