Re: database access

2000-11-16 Thread Les Mikesell
- Original Message - From: "Gunther Birznieks" <[EMAIL PROTECTED]> To: "Les Mikesell" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: "Tim Bunce" <[EMAIL PROTECTED]>; "Aaron" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED

RE: database access

2000-11-16 Thread Gunther Birznieks
r 16, 2000 4:04 AM > > To: Les Mikesell; [EMAIL PROTECTED] > > Cc: Tim Bunce; Aaron; [EMAIL PROTECTED] > > Subject: Re: database access > > > > > > 3. As a plug, I had also suggested a couple years ago that I > > would like the > > feature to be able

RE: database access

2000-11-16 Thread Geoffrey Young
> -Original Message- > From: Gunther Birznieks [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 16, 2000 4:04 AM > To: Les Mikesell; [EMAIL PROTECTED] > Cc: Tim Bunce; Aaron; [EMAIL PROTECTED] > Subject: Re: database access > > > 3. As a plug, I had al

Re: database access

2000-11-16 Thread Gunther Birznieks
r. Later, Gunther At 07:53 PM 11/15/2000 -0600, Les Mikesell wrote: >- Original Message - >From: <[EMAIL PROTECTED]> >To: "Les Mikesell" <[EMAIL PROTECTED]> >Cc: "Tim Bunce" <[EMAIL PROTECTED]>; "Aaron" <[EMAIL PROTECTED]&g

Re: database access

2000-11-15 Thread Les Mikesell
- Original Message - From: <[EMAIL PROTECTED]> To: "Les Mikesell" <[EMAIL PROTECTED]> Cc: "Tim Bunce" <[EMAIL PROTECTED]>; "Aaron" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, November 15, 2000 2:21 AM Subject: Re:

Re: database access

2000-11-15 Thread spam
On Tue, 14 Nov 2000, Les Mikesell wrote: > I wonder if Apache::DBI could figure out what connections are worth > holding open by itself? It could have some hints in the config file > like regexps to match plus a setting that would tell it not to > make a connection persist unless it had seen x

Re: database access

2000-11-14 Thread Les Mikesell
- Original Message - From: "Tim Bunce" <[EMAIL PROTECTED]> > > > > > > > Don't get me wrong here, "but", it would be nice if the undocumented > > > > somehow made it to the documented status. > > > > > > > yeah... but Apache::DBI and DBI are in cahoots! it's a secret love that > > no d

Re: database access

2000-11-14 Thread Tim Bunce
On Mon, Nov 13, 2000 at 01:55:38PM -0500, Aaron wrote: > > > > > Don't get me wrong here, "but", it would be nice if the undocumented > > > somehow made it to the documented status. > > > > yeah... but Apache::DBI and DBI are in cahoots! it's a secret love that > no documentation can break ap

Re: database access

2000-11-13 Thread Aaron
> > > Don't get me wrong here, "but", it would be nice if the undocumented > > somehow made it to the documented status. > yeah... but Apache::DBI and DBI are in cahoots! it's a secret love that no documentation can break apart! no, really it would be nice if the DBI connection "hook" was

RE: database access

2000-11-13 Thread G.W. Haywood
Hi there, On Mon, 13 Nov 2000, George Sanderson wrote: > Don't get me wrong here, "but", it would be nice if the undocumented > somehow made it to the documented status. Well don't get me wrong either, but when I thought the Guide could do with a re-write, I re-wrote it. :) 73, Ged.

RE: database access

2000-11-13 Thread George Sanderson
At 08:04 AM 11/13/00 -0500, you wrote: >I haven't followed this thread too closely, so forgive me if I'm not quite >with it... > >you can already do this with Apache::DBI... > >change DBI->connect() to the (undocumented) 6 parameter call: > > Don't get me wrong here, "but", it would be nice if th

RE: database access

2000-11-13 Thread Geoffrey Young
I haven't followed this thread too closely, so forgive me if I'm not quite with it... > > It would be very useful to be able to specify at connect time that > you don't want a particular connection to be persistent. If you have > a lot of small databases or some with different user/password > p

Re: database access

2000-11-10 Thread clayton cottingham
Les Mikesell wrote: > > Perrin Harkins wrote: > > > > On Fri, 10 Nov 2000, Tim Sweetman wrote: > > > > Would you be interested in adding support for resetting some of these to > > > > Apache::DBI? It's pretty easy to do, using PerlCleanupHandler like the > > > > auto-rollback does. It would be

Re: database access

2000-11-10 Thread Les Mikesell
Perrin Harkins wrote: > > On Fri, 10 Nov 2000, Tim Sweetman wrote: > > > Would you be interested in adding support for resetting some of these to > > > Apache::DBI? It's pretty easy to do, using PerlCleanupHandler like the > > > auto-rollback does. It would be database-specific though, so you'd

Re: database access

2000-11-10 Thread Perrin Harkins
On Fri, 10 Nov 2000, Tim Sweetman wrote: > > Would you be interested in adding support for resetting some of these to > > Apache::DBI? It's pretty easy to do, using PerlCleanupHandler like the > > auto-rollback does. It would be database-specific though, so you'd have > > to find a way for peopl

Re: database access

2000-11-10 Thread Tim Sweetman
Perrin Harkins wrote: > > On Thu, 9 Nov 2000, Tim Sweetman wrote: > > Apache::DBI is, as far as I know, dangerous, and people rarely seem to > > warn of this. > > It's no more dangerous than any other scheme for persistent connections, > like JDBC pooling, etc. > > > It's dangerous because: > >

Re: database access

2000-11-09 Thread Perrin Harkins
On Thu, 9 Nov 2000, Tim Sweetman wrote: > Apache::DBI is, as far as I know, dangerous, and people rarely seem to > warn of this. It's no more dangerous than any other scheme for persistent connections, like JDBC pooling, etc. > It's dangerous because: > (a) Although it rolls back any transaction

[OT] RE: database access

2000-11-09 Thread Joshua Gerth
> I am trying to access access Microsoft SQL server on NT from Apache Server > under Linux, > Can some one give me a direction, how/where to looking into it? > > Appreciate for any help Check out the FreeTDS libs at: http://www.freetds.org/ I use it now to contact a MS SQL 6.5 server f

RE[2]: database access => How To: Linux => WinNT ODBC Proxy

2000-11-09 Thread Christopher Taranto
plete instructions At 08:16 AM 11/9/00 -0600, you wrote: >I am trying to access access Microsoft SQL server on NT from Apache Server >under Linux, >Can some one give me a direction, how/where to looking into it? > >Appreciate for any help > >PC Wang > >-Original

Re: database access

2000-11-09 Thread Tim Sweetman
clayton cottingham wrote: > > Greg Cope wrote: > > > > Jason Liu wrote: > > > > > > Is Apache::DBI absolutely necessary if you want to establish persistent > > > database connection per child? > > > > No you can write your own (its open source remember ;-) but why bother - > > standing on the sho

RE: database access

2000-11-09 Thread Wang, Pin-Chieh
, 2000 4:11 PM To: Greg Cope Cc: Jason Liu; [EMAIL PROTECTED] Subject: Re: database access Greg Cope wrote: > > Jason Liu wrote: > > > > Is Apache::DBI absolutely necessary if you want to establish persistent > > database connection per child? > > No you can write your

Re: database access

2000-11-08 Thread clayton cottingham
ders of giants etc > > Greg > > > > > Thanks, > > > > Jason > > > > > -Original Message- > > > From: David Hodgkinson [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, November 06, 2000 5:10 AM > > > To: Jason Liu &g

RE: database access

2000-11-08 Thread Douglas Wilson
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Greg Cope > Sent: Tuesday, November 07, 2000 10:53 AM > To: Jason Liu > Cc: [EMAIL PROTECTED] > Subject: Re: database access > > > Jason Liu wrote: > > > >

Re: database access

2000-11-08 Thread Greg Cope
nks, > > Jason > > > -Original Message- > > From: David Hodgkinson [mailto:[EMAIL PROTECTED]] > > Sent: Monday, November 06, 2000 5:10 AM > > To: Jason Liu > > Cc: [EMAIL PROTECTED] > > Subject: Re: database access > > > > > > "Jason Liu&qu

RE: database access

2000-11-07 Thread Jason Liu
Thank you for the help everyone. Jason

RE: database access

2000-11-07 Thread Nigel Hamilton
HI Jason, Have a look at the source of Apache::DBI. An important part of the module is a ping method that ensures the connection handle (e.g., $dbh) doesn't go stale. You can write your own ping method by doing something like:

RE: database access

2000-11-07 Thread Jason Liu
CTED] > Subject: Re: database access > > > "Jason Liu" <[EMAIL PROTECTED]> writes: > > > In general, how should database connections be handled between > parent and > > child processes? Can you establish database connections from within a > > h

Re: database access

2000-11-06 Thread David Hodgkinson
"Jason Liu" <[EMAIL PROTECTED]> writes: > In general, how should database connections be handled between parent and > child processes? Can you establish database connections from within a > handler? Absolutely. And using Abache::DBI caches the connection handle. -- Dave Hodgkinson,

RE: database access

2000-11-06 Thread Jason Liu
Thanks for reply. I need some information in the Oracle database for access control. We have some methods in our proprietary library for Oracle access. I have a file called GateKeeper.pm that contains the access handler, sub handler{ ... }. I placed the same code inside and outside of the handl

Re: database access

2000-11-06 Thread Simon_Wilcox
Time 12:02 Copy to (bcc: Simon Wilcox/BASE/WilliamsLea) Bcc Simon Wilcox/BASE/WilliamsLea Fax to Subject database access Hi, I can access oracle

Re: database access

2000-11-06 Thread David Hodgkinson
"Jason Liu" <[EMAIL PROTECTED]> writes: > Hi, > > I can access oracle database from the main Apache process, but not from any > child processes. I am fairly new to this subject, can someone give me some > advice? What error are you getting? You looked in the error logs? What do you mean by "ma

database access

2000-11-06 Thread Jason Liu
Hi, I can access oracle database from the main Apache process, but not from any child processes. I am fairly new to this subject, can someone give me some advice? Thanks in advance, Jason