I am looking for software that will allow my web server to connect to an LDAP server,
and extract information from the ldap directory. My web server runs apache on a Sun
Solaris machine. I do most of my programming in perl and have used DBI/DBD quite
extensively.
I searched on CPAN to see if th
>
> There isn't. mod_perl and Apache::DBI allow some connection pooling,
> but
> I'm not sure how it's done. Discussing DBI handles is definitely on
> topic.
>
mod_perl + Apache::DBI doesn't do connection pooling in Apache 1.3.
The way 1.3 works is as follows:
Each Apache child has its own p
On Tue, 1 Oct 2002 14:41:53 -0700 Henri Asseily <[EMAIL PROTECTED]> wrote:
> I have an $sth being passed to a function. I want to get access to its
> $dbh, from within that function, but the $dbh isn't passed as a
> parameter.
>From DBI-1.30/Changes:
=head2 Changes in DBI 1.16,30th May 20
On Tue, 1 Oct 2002 09:38:48 -0700 (PDT) Thomas Hilbig <[EMAIL PROTECTED]> wrote:
> The recent discussion on sharing (or not!) DBI
> connections among forked/threaded processes leaves me
> wanting to know if there is a well-established method
> for sharing DBI connections among separate processes.
Sterin, Ilya wrote:
> Jeff, that's helpful:-)
>
> but that does not pupulat the excel spreadsheet with data from a select
> query, rather you have to select and loop while do()ing it.
>
> There is lot of overhead for certain things, I just though a simple mod
> would help to just dump data, and
Most of the comments are obvious from the context and BabelFish
(http://world.altavista.com/tr) can help without mangling the rest too
badly.
On Tue, 1 Oct 2002 10:39:00 -0500 "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> wrote:
> Thanks. This is definitely helpful, but the one thing I f
KAWAI,Takanori wrote:
> $hDbE->func('dump.xls', 'save');
Hmm, forget my patch, I missed that somehow :-(. Actually the one part
of the patch you might want to keep is the part that creates a new .xls
file if the one in the connect doesn't exist yet. Here's the patch for
that part. (Please
Please note that I am not Tim Bunce and I don't play him on TV. He is very
busy and you will get a quicker response if you email the list directly as
the documentation tells you to rather than having Tim relay it when he
finds the time.
On Tue, 1 Oct 2002 11:16:04 +0100 Tim Bunce <[EMAIL PROTECT
On 1 Oct, Jeff Boes wrote:
> Sorry. Does anyone here know the status of the PostgreSQL mailing
> lists? They appear to have crashed hard somewhere around 9/25 ...
pgsql-hackers is up and quite active right now, as they're getting ready for
the 7.3 release. I can't comment on the others, but i
- Original Message -
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 02, 2002 12:04 AM
Subject: Database to Excel script...
> I have a MySQL database that I have a few Perl scripts working on.
> I am now looking into doing some reporting
Thank you for your patch, Jeff.
I will (and should) update DBD::Excel.
- Original Message -
From: "Jeff Zucker" <[EMAIL PROTECTED]>
To: "Sterin, Ilya (I.)" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; " Kawai Takanori (Hippo2000)" <[EMAIL PROTECTED]>
Sent: Wednesday, October 02, 2002 6:
Jeff, that's helpful:-)
but that does not pupulat the excel spreadsheet with data from a select
query, rather you have to select and loop while do()ing it.
There is lot of overhead for certain things, I just though a simple mod
would help to just dump data, and nothing else.
I'll also look into
On Tue, Oct 01, 2002 at 04:17:51PM -0500, Jesse, Rich wrote:
> Hi,
>
> A Solaris system that I have little control over is running Perl 5.005_03,
> and a DBI_TRACE level 2 shows DBI v1.13 and DBD::Oracle v1.03. The Oracle
> client on the Solaris server is 8.0.5.0.0. The Oracle DB we're connecti
Ilya Sterin wrote:
>
>Jeff Zucker wrote
>>
>>With Kawai Takanori's DBD::Excel (on CPAN).
>
>Yes, but DBD::Excel allows you to query Excel files, not dump them.
Here's a somewhat simple minded patch to DBD::Excel that allows one to
create and populate an Excel file with standard SQL CREATE
Hello everyone.
First post here, sorry if this has already been covered elsewhere. I'd
be happy to be redirected to other references, but I couldn't find the
answer in the usual places.
Anyway, the question is simple:
I have an $sth being passed to a function. I want to get access to its
$dbh
On Mon, Sep 30, 2002 at 03:21:53PM +1200, Glen Eustace wrote:
> Tim, Is there any thing I can provide that may help resolve this issue.
> Now that I don't get perl dieing, would the DBI trace help ?
Uh, wasn't paying attention. Sorry. Yes. trace(9), just to me, not the list.
Can't promise to spe
Hi,
A Solaris system that I have little control over is running Perl 5.005_03,
and a DBI_TRACE level 2 shows DBI v1.13 and DBD::Oracle v1.03. The Oracle
client on the Solaris server is 8.0.5.0.0. The Oracle DB we're connecting
to is 8.1.7.4.0 on HP/UX.
After changing the 8.1.7 DB's characterse
Hi Ilya,
IS<>
JZ<>
IS<>
Export and convert work on any DBI supported format. To quote from the POD:
"DBD::AnyData supports importing any DBI database into memory and can
also convert any DBI database into any of the other AnyData formats."
It does the conversion a row at a time, not by i
Added CSV output functionality.
Ilya
-Original Message-
From: PAUSE
To: Ilya Sterin; [EMAIL PROTECTED]
Sent: 10/1/02 1:51 PM
Subject: CPAN Upload: I/IS/ISTERIN/DBIx-Dump-0.02.tar.gz
The uploaded file
DBIx-Dump-0.02.tar.gz
has entered CPAN as
file: $CPAN/authors/id/I/IS/ISTERIN/
I had to reinstall DBD-Oracle under the new environment. The problem was
that some of our DBs are ORacle 8x and some are 9x depending on where they
are hosted. So after Oracle was reconfigured on the OS and the oracle env
variables were set, DBD-Oracle was reinstalled and it read the updated
varia
Sorry. Does anyone here know the status of the PostgreSQL mailing
lists? They appear to have crashed hard somewhere around 9/25 ...
Even groups.google.com seems to have lost track of them ... the only
messages they have are ones posted to Google directly.
--
Jeff Boes
Does it allow you to export it from all databases, or only databases that
DBD::AnyData supports?
DBIx::Dump works with any db's handle.
Ilya
-Original Message-
From: Jeff Zucker
To: Sterin, Ilya
Cc: [EMAIL PROTECTED]
Sent: 10/1/02 11:52 AM
Subject: Re: Uploaded to CPAN: DBIx::Dump
Ster
DBIx::Dump :-)
https://pause.perl.org/pub/PAUSE/authors/id/I/IS/ISTERIN/DBIx-Dump-0.01.tar
Ilya
-Original Message-
From: NIPP, SCOTT V (SBCSI)
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Sent: 10/1/02 9:39 AM
Subject: RE: Database to Excel script...
Thanks. This is definit
DBIx::Dump allows to dump DBI result set into a variety of formats like
Excel, CSV, XML, etc...
Right now, it only dumps to Excel, tomorrow's release will dump into CSV as
well, then sometime this week it will dump into XML...
If you'd like to see another format, please let me know or submit a p
The recent discussion on sharing (or not!) DBI
connections among forked/threaded processes leaves me
wanting to know if there is a well-established method
for sharing DBI connections among separate processes.
While it may be off topic for the DBI list, I can't
think of a better use for it than a
See below.
>
>
> Hi,
>
> I am using Perl with DBD-ODBC to extract live values from an Wonderware
> Industrial SQL which runs on top of a Microsoft SQL Server.
>
> The platform is Windows NT 4.0, Microsoft SQL Server 6.50.193 and
> Industrial
> SQL version 7.0.211, Microsoft SQL Server ODBC versio
Yes, but DBD::Excel allows you to query Excel files, not dump them.
Ilya
-Original Message-
From: Jeff Zucker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 11:37 AM
To: dbi-users
Subject: Re: Database to Excel script...
Sterin, Ilya wrote:
> You can easily accomplish that
Thanks. This is definitely helpful, but the one thing I find a bit
funny is the comments in the code... I think I recognize it as German, but
being a stupid American, English is the only language I actually speak. :)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PRO
Sterin, Ilya wrote:
> You can easily accomplish that by dumpin into a CSV (comma separated file)
> with .csv extension which will open in excel as you want.
Here's one for the FAQ:
How do I use DBI with Excel?
With Kawai Takanori's DBD::Excel (on CPAN). It provides a DBI interface
on top of
Yes. I also am using phpMyAdmin for some queries, but I am actually
looking to create a cron job that will run a monthly report and e-mail the
resulting Excel file to a couple of individuals. I am able to do all of
this manually at this time, but I would really like to automate the process
i
Here we go:
>
> I have a MySQL database that I have a few Perl scripts working on.
> I am now looking into doing some reporting on these database tables. I
> would really like to find a script that queries the database and the uses
> the Spreadsheet::WriteExcel module to output the data
You can easily accomplish that by dumpin into a CSV (comma separated file)
with .csv extension which will open in excel as you want.
Ilya
-Original Message-
From: NIPP, SCOTT V (SBCSI)
To: '[EMAIL PROTECTED]'
Sent: 10/1/02 9:04 AM
Subject: Database to Excel script...
I have a My
Our first mirror, thanks to David Murray.
We really appreciate your help.
Ilya Sterin
I have a MySQL database that I have a few Perl scripts working on.
I am now looking into doing some reporting on these database tables. I
would really like to find a script that queries the database and the uses
the Spreadsheet::WriteExcel module to output the data directly to an Excel
fi
Hi,
I am using Perl with DBD-ODBC to extract live values from an Wonderware
Industrial SQL which runs on top of a Microsoft SQL Server.
The platform is Windows NT 4.0, Microsoft SQL Server 6.50.193 and Industrial
SQL version 7.0.211, Microsoft SQL Server ODBC version 3.70.0961.
When I use:
DB
Thanks to a wonderful volunteer who came forward (David Crown) the old FAQ
has now been uploaded into the new DBI FAQ www.xmlproj.com/cgi/fom.cgi
You can now update your bookmarks, as the new FAQ contains all of DBI FAQ
currently available.
Ilya Sterin
PPM is used to install prebuilt modules - you don't need to do make the
software.
In order to install the latest versions of DBI and DBD-ODBC as Jeff
advised you need to set the repository to point other than at Activestate
before doing the install:
At a command prompt type PPM:
PPM> set r
Hi all.
DBD:ODBC installed and worked well after upgrading to 1.30. Anyway, Editing
the makefile was important to make it work as suggested by jeff. Thanks a
lot for the (long) support.
I have one more query over the list.
Can i specify the server_name and Database_Name in the perl script rathe
Oh ok so run the make commands etc in the ppm install console.
Will give that a try.
Do you have any ideas on my other problem.
On another note what I would really like to do is access my SQLserver
database via tcp/ip comms from a remote raq server running perl. Is this
possible and if so
Tim,
Attached
is the output, according to the README, of errors I'm getting while
compiling DBD-Oracle-1.12. Is there a solution to the compiler errors?
Thanks.
Ian
Ultra 5, 198RAM, 20GB and 4GB drives
Solaris 9 from www.sun.com
Perl 5.8 precompiled from www.sunf
Well, actually David Crown is already doing this:-) Michael if you'd like to help him
out, please contact him.
What we'll need help with is later properly editing and categorizing this stuff, as
some of it needs some major updating.
I have not yet forwarded the changes to FAQ email to go to t
Try searching for your answer in the DBI FAQ www.xmlproj.com/cgi/fom.cgi
first. Then, if that doesn't help, post the error information, version of
perl, version of DBI, version of DBD::ODBC along with the code again.
Regards,
Jeff
>
> Hi
>
> I am trying database connectivity using DBI/ODBC thru
What is the error that you get?
> when i run the perl file thru command
> >perl test.pl it gives me reult but when i run it on server
> >using
> http://localhost/cgi-bin/test.pl it gives error.
__
Do you Yahoo!?
New DSL Internet Access from SBC
On Mon, Sep 30, 2002 at 06:24:52PM -0600, Sterin, Ilya wrote:
> Forwarding to dbi-dev. This is where it belongs.
Actually for the initial discussion dbi-users is probably the best
place to explore what's needed. After that dbi-dev would be better
for the detailed design work.
Tim.
> Sam: Subsc
On Mon, Sep 30, 2002 at 06:27:38PM -0400, Sam Tregar wrote:
> Hello all. I'm thinking about creating a DBI::Profile subclass to enable
> profiling of database queries in large Apache/mod_perl applications.
Excellent. I was hoping someone would.
> Here's my plan:
>
> - At runtime, instead of
On Mon, Sep 30, 2002 at 08:01:54PM -0400, Matthew O. Persico wrote:
> On Mon, 30 Sep 2002 09:56:20 +0100, Tim Bunce spaketh:
> >On Sun, Sep 29, 2002 at 06:37:01PM -0400, Matthew O. Persico wrote:
>
> [snippage]
>
> >Q: How do I share a database handle between a parent and its child
> >process? ?
Stack trace - from the core file. Not a DBI trace log.
Tim.
On Mon, Sep 30, 2002 at 03:21:53PM +1200, Glen Eustace wrote:
> Tim, Is there any thing I can provide that may help resolve this issue.
> Now that I don't get perl dieing, would the DBI trace help ?
>
> On Thu, 2002-09-26 at 10:11, Gl
On Mon, Sep 30, 2002 at 02:58:28PM -0700, Michael A Chase wrote:
> On Mon, 30 Sep 2002 13:34:17 -0600 "Sterin, Ilya" <[EMAIL PROTECTED]> wrote:
>
> > In search for a volunteer to transfer the answers from the old FAQ, which
> > are not already in the new version and update the FAQ-O-Matic. If an
I did originally in attachments, but the server must have cropped them off.
I am running Win2k. and perl5 (revision 5 version 6 subversion 1)
I am trying to install the DBI-1.25 module. to access databases.
On another note what I would really like to do is access my SQLserver database via
tc
Hi
I am trying database connectivity using DBI/ODBC thru perl in
web
page when i run programme locally(standalone not on any server)
it
works well but when i run it thru server it gives exception
while
connecting to database.I am using apache server.I am new to perl
so can anyone tell whether
However --
DBI and DBD::ODBC in ActiveState's repository are SADLY out of date. You
can get the PPDs and tar.gz files from:
ftp://ftp.esoftmatic.com/outgoing/DBI
Regards,
Jeff
>
> OK. If you're using Windows, then you shouldn't need to make anything.
> If you haven't already, get hold of Activ
- Forwarded message from Namita C <[EMAIL PROTECTED]> -
Delivered-To: [EMAIL PROTECTED]
X-Originating-IP: [209.244.239.181]
From: "Namita C" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: DBD-Oracle-1.12 makefile compilation problem
Date: Tue, 01 Oct 2002 03:44:2
OK. If you're using Windows, then you shouldn't need to make anything.
If you haven't already, get hold of ActivePerl from www.Activestate.com,
and then use PPM to install whichever modules you need. To access
SQLServer you'll need DBI and DBD-ODBC.
Regards.
Rob
-Original Message-
53 matches
Mail list logo
