PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: timeout Sybase:Simple 0.52
Date: Jul 12 2002 12:26AM

On Thu, 2002-07-11 at 16:45, dean.l.chang@verizon.com wrote:
> Hi Michael,
> 
> Re: Sybase::Simple 0.52-- I know it's still beta, but can the timeout be 
> set using %attr or some other way?
> 
> Script started on Thu Jul 11 19:43:11 2002
> $ ../dbi_hpfrj1.pl
> OC: 63 2 ct_connect(): user api layer: internal Client Library error: Read 
> from the server has timed out.
> OC: 63 2 ct_connect(): user api layer: internal Client Library error: Read 
> from the server has timed out.
> OC: 63 2 ct_connect(): user api layer: internal Client Library error: Read 
> from the server has timed out.
> OC: 4 5 ct_connect(): network packet layer: internal net library error: 
> Net-Lib protocol driver call to connect two endpoints failed OS: TLI 
> connect call failed - t_errno 9

Hmmm... That's the login timeout. You should be able to set it the same
way that it's set for Sybase::CTlib:

ct_config(CS_SET, CS_LOGIN_TIMEOUT, 120, CS_INT_TYPE);
ct_config(CS_SET, CS_TIMEOUT, 120, CS_INT_TYPE);

The above sets both timeouts to 120 seconds. The default is 60 seconds.

You can also set the timeout value to CS_NO_LIMIT, which means that the
login call will not timeout.

Michael
-- 
Michael Peppler / mpeppler@peppler.org / http://www.mbay.net/~mpeppler
mpeppler@zetatools.com / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!