Re: Some problems using component

let me  clear one thing  r u using MTS?
if u r using MTS  then no need to add ref.
rgds
Hitesh Shah

----- Original Message -----
From: "roopa" <[email protected]>
To: <[email protected]>
Sent: Wednesday, May 08, 2002 11:47 AM
Subject: Re: [VBCOM] 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.

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