coolphilboy
Technical User
I'm calling an SQL Server SP in VB. The procedure runs for about 30 mins. in the Query Analyzer. But when I call the procedure in VB it seems that the Procedure is terminated abnormally without any warning from VB.
I've set the ConnectionTimeout=0 and the CommandTimeout=0, but it doesn't seem to work. The same procedure is working normally when executed in the Query Analyzer. Is there something i've missed to set? PLEASE HELP !!!
I've set the ConnectionTimeout=0 and the CommandTimeout=0, but it doesn't seem to work. The same procedure is working normally when executed in the Query Analyzer. Is there something i've missed to set? PLEASE HELP !!!