Return-Path: Mailing-List: contact modperl-help@apache.org; run by ezmlm Delivered-To: mailing list modperl@apache.org Received: (qmail 78742 invoked from network); 21 Mar 2000 16:08:29 -0000 Received: from pingu01.softronic.ch (HELO s1059.softronic.ch) (194.209.111.100) by locus.apache.org with SMTP; 21 Mar 2000 16:08:29 -0000 Received: by s1059.softronic.ch with Internet Mail Service (5.5.2448.0) id ; Tue, 21 Mar 2000 17:08:02 +0100 Message-ID: <51A0A94DBD68D0119224080009ED78103038E3@s1059.softronic.ch> From: Ender Josef To: "'modperl@apache.org'" Subject: Apache crashes every second db request Date: Tue, 21 Mar 2000 17:08:01 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="iso-8859-1" X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N I'm trying to move my CGI scripts to run with Apache and mod_perl to allow a permanent connection to the Database. All is working fine if I let run the scripts as CGI script. If I run the following simple script-snippet with Apache::Registry or Apache::PerlRun I get the correct values back the first time. The second time I run the script Apache.exe crashes. If I restart apache between this two requests its working again. I guess apache crashes every time the database connection still exists. I'm using Apache/1.3.9 Win32 mod_perl 1.21. I tried with SQL Anywhere 5.5 and MS-SQL 6.5. We have also exactly the same problem with Apache 1.3.11 and Jserve 1.1: Java.exe crashes every second DB-request. ---snip--- use Win32::ODBC; my $DB = new Win32::ODBC("DSN=$dsn;UID=$uid;PWD=$pwd"); $DB->Sql("select id from dba.licenses where id = '10'"); $DB->FetchRow(); $db_val = $DB->Data; print $db_val; $DB->Close(); ---snip--- Any help is greatly appreciated Josi