On Fri, 2004-07-02 at 20:19, David Good wrote:
> I'm having trouble with DBD::Sybase 1.04 on ActivePerl 5.8.4 (build 810) 
> on Windows.  It seems to hang when connecting.  Here's a sample script 
> that exercises the problem:

>     >> DESTROY     DISPATCH (DBI::st=HASH(0x1c1ca7c) rc1/1 @1 g0 ima4 pid#2184) at 
> c:/Perl/site/lib/DBD/Sybase.pm line 99 via foo line 10
>     -> DESTROY for DBD::Sybase::st (DBI::st=HASH(0x1c1ca7c)~INNER) thr#15d4a54
>     syb_st_finish() -> ct_cancel(CS_CANCEL_ALL)

I don't know why, but the ct_cancel() call often causes problems - in
particular if the client and the server aren't on the same network (i.e.
firewalls, routers, etc.)

Try adding the syb_flush_finish => 1 attribute in the connect() call,
and read about this attribute in the DBD::Sybase docs.

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
[EMAIL PROTECTED]                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html


Reply via email to