Re: Solved: DBD::Oracle crashes IRIX server hard

2001-09-10 Thread Tim Bunce
I'd be grateful if you could send me some updated docs for the README.help file (ideally as a contect diff). Tim. On Wed, Sep 05, 2001 at 10:09:12PM +0400, Ivan Adzhubei wrote: Hi! We finally fixed the problem today and of course Tim was right -- it was IRIX system bug that caused the

Re: Install DBI-1_20 FAILED

2001-09-10 Thread Tim Bunce
You'll need to get someone on the perl VMS mailing list (I forget the address) to fix it and send me a patch. Tim. On Mon, Sep 03, 2001 at 03:15:14PM +0200, Pavel Smejkal wrote: Hi ,all I have some problem with building DBI on Alpha OpenVMS V7.3 I download package DBI-1_20 from CPAN.

Re: Is there an easy way to determine where this...

2001-09-10 Thread Tim Bunce
On Tue, Sep 04, 2001 at 01:35:30PM -0400, Jim Lynch wrote: OK, thanks. I thought the hash being reported was the database handle, I wasn't aware it was the object I haven't finished handle. It is the db handle. There's no easy way to report the statement handles. I could possibly add

Re: dbi-proxy forwarding

2001-09-10 Thread Tim Bunce
On Thu, Sep 06, 2001 at 02:18:02PM +0100, Mark Buckle wrote: Is it possible to connect to a proxy server in a pass-through kind of way, ie connect from machine A to Machine C via machine B. Both B and C would be runing dbi-proxy. Yes, at least in theory. Try it. Tim. This question is

CPAN versions old

2001-09-10 Thread Hardy Merrill
Slightly off topic, but... I've recently been playing with my CPAN module configuration trying to come up with CPAN sites in my general vacinity that I can use with CPAN to install perl modules - specifically DBI and DBD modules. Since Tim recently announced new versions of DBI and DBD::Oracle,

Re: Web interface?

2001-09-10 Thread Jeff Boes
On Sun, 9 Sep 2001 11:50:18 +0600 Alex Gerasev [EMAIL PROTECTED] wrote: Let me briefly explain what I need: I'm working on application that uses perl DBI internally and provides web user interface. I need to be able to provide nice database table access from the web, i.e. view tables (or

Bug in DBD::Pg table_attributes?

2001-09-10 Thread Jeff Boes
Sent this originally about 10 days ago, didn't see any response. Is this a bug, or am I doing something wrong? -- This looks like a bug to me. I'm using $db-func('table_name', 'table_attributes') under DBD::Pg to retrieve and process the primary keys of a table, but I've found a case

DBD:Oracle Make test error

2001-09-10 Thread Satyanarayana, KJ
I am trying to compile DBD::Oracle v1.09 using Perl 5.6.1 and DBI 1.2. I am getting errors while running make test. Can any one please tell me why is this happening? Thanks. perl.version test.err perl.version test.err

ORA-12222: TNS:no such protocol adapter

2001-09-10 Thread Andrey Bronfin
Dear gurus ! just installed ActivePerl5 (revision 5 version 6 subversion 1) , DBD-Oracle [1.03 ] DBI [1.13 ] Trying to connect to Oracle 8.0.5 DB : $dbh = DBI-connect(dbi:Oracle:,bro/bro@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOS

DBI Freezeup?

2001-09-10 Thread Ken Speich
A little bit a a peculiar situation I am running into... I have a script that I wrote that runs in an endless while loop. the structure is basically like this: ConnectToDB(); while(1) { do all my stuff in here... } The script works fine... except that every once in a while, the

RE: DBI Freezeup?

2001-09-10 Thread Sterin, Ilya
The script and specs you provided are not enough to make any reasonable recommendation. Also you might want to run a trace DBI-trace(2, trace.log) on your script and retrive after the freeze up. The file might get pretty large, but look towards the bottom of trace.log once the script stops

DBD::CSV problem sorting ISO style dates

2001-09-10 Thread Alex Schuilenburg
Hi I have successfully been using DBD::CSV for the last year and recently upgraded to Red Hat 7.0 from 6.2. The problem is that ever since the upgrade, the ORDER BY clause on an ISO date field (i.e -mm-dd,m e.g. 2001-09-10) no longer works. The sort comparison stops on the year (i.e. The

RE: Perl Questions

2001-09-10 Thread dwilkers
Hi, while noone seems to want to give any detail, rule of thumb for me:-) make clean perl Makefile.PL make make test make install -2C On Sun, 9 Sep 2001, Sterin, Ilya wrote: Not sure what you are doing, if the Makefile.PL file (make sure your use the right case) is in the current

Perl DBI Question

2001-09-10 Thread Paul Maine Jr.
I am writing a Perl/DBI application. I need to initially issue a select statement and then determine if any records are returned. Could someone provide me with an example of how to determine if no records are returned from a select statement. Thank You

Re: Perl Questions

2001-09-10 Thread Ron Clark
[EMAIL PROTECTED] wrote: Hi, while noone seems to want to give any detail, rule of thumb for me:-) make clean perl Makefile.PL make make test make install -2C On Sun, 9 Sep 2001, Sterin, Ilya wrote: Not sure what you are doing, if the Makefile.PL file (make sure your use the

RE: Perl DBI Question

2001-09-10 Thread Wilson, Doug
From: Paul Maine Jr. [mailto:[EMAIL PROTECTED]] I am writing a Perl/DBI application. I need to initially issue a select statement and then determine if any records are returned. Could someone provide me with an example of how to determine if no records are returned from a select

RE: Perl Questions

2001-09-10 Thread Sterin, Ilya
Yep, that's probably it, way to notice. Ilya -Original Message- From: Ron Clark To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: 9/10/01 1:43 PM Subject: Re: Perl Questions [EMAIL PROTECTED] wrote: Hi, while noone seems to want to give any detail, rule of thumb for me:-) make clean

Re: DBD::CSV problem sorting ISO style dates

2001-09-10 Thread Alex Schuilenburg
Alex Schuilenburg wrote: Hi I have successfully been using DBD::CSV for the last year and recently upgraded to Red Hat 7.0 from 6.2. The problem is that ever since the upgrade, the ORDER BY clause on an ISO date field (i.e -mm-dd,m e.g. 2001-09-10) no longer works. The sort

Re: DBD::CSV problem sorting ISO style dates

2001-09-10 Thread Jeff Zucker
Alex Schuilenburg wrote: Hi I have successfully been using DBD::CSV for the last year and recently upgraded to Red Hat 7.0 from 6.2. The problem is that ever since the upgrade, the ORDER BY clause on an ISO date field (i.e -mm-dd,m e.g. 2001-09-10) no longer works. The sort

Re: CPAN versions old

2001-09-10 Thread Tim Bunce
Perhaps you need to talk to the people who run the mirrors. If it works okay just using the 'master' site then it's a mirror problem. Tim. On Mon, Sep 10, 2001 at 09:22:38AM -0400, Hardy Merrill wrote: Slightly off topic, but... I've recently been playing with my CPAN module configuration

RE: Perl Questions

2001-09-10 Thread Gary L. Burnore
At 15:36 09/10/2001, [EMAIL PROTECTED] wrote: Hi, while noone seems to want to give any detail, rule of thumb for me:-) make clean ^^^ Better: make realclean (and remove any config.sh or Policy.sh files if you really want to start from scratch) perl Makefile.PL make make test

DBD::CSV problem sorting ISO style dates

2001-09-10 Thread Alex Schuilenburg
Hi I have successfully been using DBD::CSV for the last year and recently upgraded to Red Hat 7.0 from 6.2. The problem is that ever since the upgrade, the ORDER BY clause on an ISO date field (i.e -mm-dd,m e.g. 2001-09-10) no longer works. The sort comparison stops on the year (i.e.

** DBD INSTALLATION USING GCC ON HPUX 11 **

2001-09-10 Thread Gretton, Michael , , WHS/PSD
To All: I have been fighting this problem for weeks and I am close to giving up. My environment is as follows: HPUX 11.00, Perl 5.6.1 (compiled according to the README.hpux notes). I am using GCC to compile the code. My make test for perl was clean except for two scripts that failed grent.t

RE: ORA-12222: TNS:no such protocol adapter

2001-09-10 Thread Dan Horne
Andrey the ora-1 error normally occurs when there is a syntax error in your connect string. Try using the alias in your tnsnames.ora file instead my $dbh = DBI-connect(dbi:Oracle:$db_sid, $db_user, $dp_pass) where $db_sid is the alias name. When you mentioned that SQL*plus can connect,

This connection with DBD::Oracle

2001-09-10 Thread Jay Strauss
Hi, Is there any attribute(s) of the database handle that identify the sid and serial# of the connection? That is, I want to use DBI to kill some sessions (but I don't want to kill myself). Or is there a table/view like dual that contains this session's information? I can probably find my

RE: This connection with DBD::Oracle

2001-09-10 Thread Steven Baldwin
Try this ... select * from v$session where audsid = userenv ('sessionid') Steve -Original Message- From: Jay Strauss [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 11 September 2001 10:38 AM To: [EMAIL PROTECTED] Subject: This connection with DBD::Oracle Hi, Is there any attribute(s) of

RE: This connection with DBD::Oracle

2001-09-10 Thread Dan Horne
Try userenv('SESSIONID') to discover your own session's audsid SQL select userenv('SESSIONID') from dual; USERENV('SESSIONID') 13591 SQL select sid,serial#,audsid,program from v$session where audsid=13591; SIDSERIAL# AUDSID PROGRAM

strange perl problems....

2001-09-10 Thread Rajeev Nalluri
Hi all, I am having a strange problem. I used to have few perl scripts working fine until recently I moved to AIX 4.3.3 from 4.3.1. With the new version of OS, in all of my perl scripts, if I am running any shell commands or other perl scripts using backticks are failing in the following

DBI , DBD installation

2001-09-10 Thread Ruchi Varma
Hello, I downloaded DBI and DBD modules form the http://dbi.symbolstone.org/ web site. Though I was successful in installing the DBI module, I could not install the DBD module. I get the follwing error when I install the DBD module

Re: Perl DBI Question

2001-09-10 Thread dave keefer
Paul Maine Jr. wrote: I am writing a Perl/DBI application. I need to initially issue a select statement and then determine if any records are returned. Could someone provide me with an example of how to determine if no records are returned from a select statement. Thank You how about

Re: DBI , DBD installation

2001-09-10 Thread Gary L. Burnore
At 18:47 09/10/2001, Ruchi Varma wrote: Hello, I downloaded DBI and DBD modules form the http://dbi.symbolstone.org/ web site. Though I was successful in installing the DBI module, I could not install the DBD module. I get the follwing error when I install the DBD module

ANNOUNCE: Oracletool v1.3.0

2001-09-10 Thread Adam vonNieda
Hi folks, Oracletool 1.3.0 is now available for download at http://www.oracletool.com. Thanks to all who have contributed and supported! Regards, -Adam vonNieda Changelog follows.. News Oracletool is published! Oracletool was chosen as one of the many tools

Perl DBI installation question

2001-09-10 Thread Alexeyev, Tanya
Hi Tim, We had a problem when we run make and the following commands. We have: # uname -a HP-UX hpdbs01 B.11.00 B 9000/800 1882750491 16-user license and Sybase --- Adaptive Server Enterprise/11.9.2.4/1166/P/SWR 9319 ROLLUP/HP9000-735/HP-UX 10. Here is a list of our

Re: [PATCH DBI] RE: [BUG] DBI 1.20, bleadperl and 64 bit ints not mixing too well

2001-09-10 Thread Tim Bunce
Excellent, many thanks! Tim. On Mon, Sep 10, 2001 at 01:12:46PM +0100, Robin Barker wrote: Tim The attached patch corrects various pointer cast, printf format and computed value not used warning from DBI; which I found following up the following messages. I was using perl-5.7.2@11938,