DBPROCESS Dead Or not enable

[Charles Colaco]

ENV:

Windows NT
Powerbuilder 5.4
MS-SQL 6.5

"Charles Colaco" <Char...@med-sys.com> wrote in message
news:SK9wtDm...@forums.sybase.com...
> Hi there,
>
> I am getting this error while trying to save. In the Pfc_endtran event I
> execute a Store Procedure which goes and updated some info. this error is
> not coming continuously, It come once in five time. I also checked whether
> this error is cause by the store procedure, But I don't think so, because
> when I ran he store procedure from the query window and it works fine.
>
> I am attracting the SQL error log and the Store procedure for ref.
Search
> for Get_Shared_Choice_Grp in the SQL error log )
>
>
> thanks in advance
>
>
>

[Mike Swaim]

"Charles Colaco" <Char...@med-sys.com> wrote in message
news:SK9wtDm...@forums.sybase.com...
> Hi there,
>
> I am getting this error while trying to save. In the Pfc_endtran event I
> execute a Store Procedure which goes and updated some info. this error is
> not coming continuously, It come once in five time.

I've seen that with the DBLib client and 16 bit code. It happened because
another application was also doing WinSock processing, and DBLib timed out.

Mike Swaim
Michae...@enron.com

[Charles Colaco]

Thanks for replying, But Can u give me little more info. Or what am I
suppose to do.

"Mike Swaim" <Michae...@enron.com> wrote in message
news:VL8bg$oSAH...@forums.sybase.com...

[Victor Reinhart]

I got this problem sporadically in 16-bit dblib. The solution was to put
the dblib dll's on the local hard drive. When those dll's are on a network
drive, you are at risk of a timeout problem. Made all the difference in the
world. We went from 5 timeouts per day to no timeouts ever.

"Charles Colaco" <Char...@med-sys.com> wrote in message

news:6B7ZB3y...@forums.sybase.com...