Jie, I have had the same problem, and still haven't found a solution. Mine may be caused by talking through a SQL 6.5 server to a SQL 7.0 server, but I am not sure. If you find out anything else about this, please let me know. Chris -----Original Message----- From: Jie Gao [mailto:[EMAIL PROTECTED]] Sent: Friday, June 09, 2000 3:27 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: DBD::Sybase problem Hi All, DBD::Sybase v 1.22 DBI 1.13 Apache::DBI v 1.44 mod_perl/1.23 Apache/1.3.12 Solaris/Sparc 7 Using cached connnection with: Apache::DBI->connect_on_init("DBI:Sybase:$db_name", $db_user_name, $db_user_pwd); in start_up.pl. Server starts ok and all goes well; but after a few hours I get server errors, with the following in the error_log: [Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': DBD::Sybase::db ping failed: OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60) [Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': Message String: ct_cancel(CONN,ALL): user api layer: external error: There is a usage error. This routine has been called at an illegal time. [Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60) [Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': Message String: ct_close(FORCE): user api layer: external error: There is a usage error. This routine has been called at an illegal time. [Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': DBD::Sybase::st execute failed: OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60) [Fri Jun 9 08:36:44 2000] PerlHandler subroutine `Apache::Registry::handler': Message String: ct_command(): user api layer: external error: There is a usage error. This routine has been called at an illegal time. [Fri Jun 9 08:36:44 2000] [error] Database select error: OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60) Message String: ct_command(): user api layer: external error: There is a usage error. This routine has been called at an illegal time. Any idea why this is happening? Thanks very much, Jie
