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 also suggested a couple years ago

RE: database access

2000-11-16 Thread Gunther Birznieks
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 to specifically not having the ping() method by Apache::DBI if the database had already

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] Sent: Thursday, November 16, 2000 3:04 AM Su

Re: database access

2000-11-16 Thread Gunther Birznieks
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]; [EMAIL PROTECTED] Sent: Wednesday, November 15, 2000 2:21 A

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-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: database access On Tue, 14 Nov

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 documentation can

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 apart!

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

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 the

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 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-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: (a) Although

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 people to

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 have

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 database-specific

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 own (its open source remember

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 shoulders of giants etc

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

2000-11-09 Thread Christopher Taranto
oft 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 Message- From: clayton cottingham [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 08, 2000 4:11 PM To: Greg Cope Cc: Jason

[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 from

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 transactions

Re: database access

2000-11-08 Thread Greg Cope
- 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" [EMAIL PROTECTED] writes: In general, how should database connections be handled betwee

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: Is Apache::DBI absolutely necessary if you want

Re: database access

2000-11-08 Thread clayton cottingham
, 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" [EMAIL PROTECTED] writes: In general, how shoul

RE: database access

2000-11-07 Thread Jason Liu
: 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 handler? Absolutely. And using Abache::DBI caches the connection handle.

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
Thank you for the help everyone. Jason

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

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 "main"

Re: database access

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

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

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,