Re: mod_perl/DBI problem

2001-07-31 Thread Curtis Hawthorne
Message - From: Ged Haywood [EMAIL PROTECTED] To: Curtis Hawthorne [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, July 27, 2001 4:19 PM Subject: Re: mod_perl/DBI problem Hi there, On Fri, 27 Jul 2001, Curtis Hawthorne wrote: So, how can I have it try to connect to the database

RE: mod_perl/DBI problem

2001-07-31 Thread Geoffrey Young
-Original Message- From: Curtis Hawthorne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 10:47 AM To: [EMAIL PROTECTED] Subject: Re: mod_perl/DBI problem Even when using Apache::DBI, I still have the same problem - If it times out once, it won't try again. I set

Re: mod_perl/DBI problem

2001-07-31 Thread Curtis Hawthorne
[EMAIL PROTECTED] To: 'Curtis Hawthorne' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 31, 2001 10:04 AM Subject: RE: mod_perl/DBI problem snip the way most people handle this is by separating out the connect routine, wrapping it in an eval, and calling $r-child_terminate if $dbh

RE: mod_perl/DBI problem

2001-07-31 Thread Geoffrey Young
-Original Message- From: Curtis Hawthorne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 12:24 PM To: [EMAIL PROTECTED] Subject: Re: mod_perl/DBI problem That looks like that will do exactly what I need. I tried it my code and it caught the server timeout

RE: mod_perl/DBI problem

2001-07-31 Thread Geoffrey Young
-Original Message- From: Geoffrey Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 12:46 PM To: 'Curtis Hawthorne'; [EMAIL PROTECTED] Subject: RE: mod_perl/DBI problem yup, looks like mod_perl doesn't offer that to windows. well, I don't do windows, but maybe

Re: mod_perl/DBI problem

2001-07-31 Thread Curtis Hawthorne
in my analysis of the problem? Really confused, Curtis H. - Original Message - From: Geoffrey Young [EMAIL PROTECTED] To: 'Curtis Hawthorne' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 31, 2001 11:49 AM Subject: RE: mod_perl/DBI problem -Original Message- From

RE: mod_perl/DBI problem

2001-07-31 Thread Geoffrey Young
-Original Message- From: Curtis Hawthorne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 3:48 PM To: Geoffrey Young; [EMAIL PROTECTED] Subject: Re: mod_perl/DBI problem Well, that works perfectly, but doesn't do anything :-). As far as I can tell, because my

Re: mod_perl/DBI problem

2001-07-31 Thread Curtis Hawthorne
gotten around to it :-) Anyways, much thanks for all your help! Curtis H. - Original Message - From: Geoffrey Young [EMAIL PROTECTED] To: 'Curtis Hawthorne' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 31, 2001 3:14 PM Subject: RE: mod_perl/DBI problem snip hmph, it's been

mod_perl/DBI problem

2001-07-27 Thread Curtis Hawthorne
I'm writing a script that will run under mod_perl that uses DBI to connect to an MS SQL server. The script works fine and mod_perl speeds it up quite a bit. Every so often, when the script tries to connect to the SQL server, the connection times out (I think the SQL server's a little slow), and

Re: mod_perl/DBI problem

2001-07-27 Thread Ged Haywood
Hi there, On Fri, 27 Jul 2001, Curtis Hawthorne wrote: So, how can I have it try to connect to the database again if it fails, but keep the connection persistent if it doesn't? Have a look in the Guide, there's lots of stuff in there about Apache::DBI. http://perl.apache.org/guide. 73,

apache/mod_perl/dbi - problem

1999-12-13 Thread Volker Hess
Hi, I use to servers with nearly the same configuration: host 1: Embedded Perl version 5.00503 for Apache/1.3.9 (Unix) Debian/GNU AuthPostgreSQL/0.7.1 mod_perl/1.21 process 255, running since Mon Dec 13 10:57:03 1999 completely using debian packages host 2: Embedded Perl

Re: apache/mod_perl/dbi - problem

1999-12-13 Thread Stas Bekman
On Mon, 13 Dec 1999, Volker Hess wrote: Hi, I use to servers with nearly the same configuration: host 1: Embedded Perl version 5.00503 for Apache/1.3.9 (Unix) Debian/GNU AuthPostgreSQL/0.7.1 mod_perl/1.21 process 255, running since Mon Dec 13 10:57:03 1999 completely

Re: apache/mod_perl/dbi - problem

1999-12-13 Thread Volker Hess
Thanx Stas, Doesn't it print the reason for the failure? Is your code looking like: man DBI: $dbh = DBI-connect($data_source, $username, $password) || die $DBI::errstr; I mean, do you use $DBI::errstr? It can be a permission problem, your script is