Re: Some problems using component

Hi Hitesh

i have checked the stored procedure, it is updating just 2 fields of data.
and my execution time is unlimited.
But the same no change

and component does not respond for long as i said 5-7 min or hangs

and i get those normal component not responding switch to ,retry
when i press switch to sometimes works that is 5-7 min case and some times
hangs and have to terminate and restart.

one more problem i am facing is the reference to the dll lost have way when
executing the exe file.so again have to restart application.

can you tell me what may be wrong

thanks'with regards
roopa


On Mon, 6 May 2002 09:27:00 +0530, hitesh shah <[email protected]>
wrote:

>i think this is bacuase ,some time it is taking long time to exec .
store
>proc.
>just check ur proc. and try to reduce long query ..
>or just increase  (or zero for unlimited) query exec time out period in
>sqlserver or command exec time in prog..
>rgds
>Hitesh Shah
>
>
>----- Original Message -----
>From: "roopa" <[email protected]>
>To: <[email protected]>
>Sent: Sunday, May 05, 2002 6:18 PM
>Subject: [VBCOM] Some problems using component
>
>
>> hi all
>> i am facing some problems with the component
>>
>> 1. most of the times my functions in the component works well and give
>> correct results. But sometimes when i try to execute the fucntion it
>raises
>> an error. i failed to understand why this happens.
>>
>> for eg:1. i am extracting data from a table using stored procedure. i am
>> able to view all data.
>> 2. i try to add raises an error. when i try to go debug it when goes to
>> rs.execute it waits for long meaning executes the procedure at times 7-8
>> mins later raises an error,or hangs.
>>
>> 3. at times this happens after i have added  the record when i do a
>> retreive.
>>
>> these i have faced very rarely but it is quite difficult to tell  when
>this
>> can happen.
>> please any suggestions withh be vey usefull
>>
>> thanks in advance
>> roopa
>>
>> You can read messages from the VBCOM archive, unsubscribe from VBCOM, or
>> subscribe to other DevelopMentor lists at http://discuss.develop.com.
>
>You can read messages from the VBCOM archive, unsubscribe from VBCOM, or
>subscribe to other DevelopMentor lists at http://discuss.develop.com.

You can read messages from the VBCOM archive, unsubscribe from VBCOM, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.