Can't make DBD::Oracle on OS X

2002-09-12 Thread Tom Mornini
I'm trying make DBD::Oracle on Macintosh OS X against Oracle Developer Preview release. DBI-1.30 compiled and tested cleanly. I'm attaching the entire output of: perl Makefile.PL for DBD::Oracle 1.12 Other than minor errors like: Multiple copies of Driver.xst found in: /Library/Perl/darwin/a

Re: DBD::Informix

2002-09-12 Thread Jonathan Leffler
Webb Linda-ra0546 wrote: > I am loading DBD::Informix on hpux 11.0. Unfortunately Perl is installed for 32 bit >os, now when I type make it gives me the following error: > > LD_RUN_PATH="" ld -o blib/arch/auto/DBD/Informix/Informix.sl -b Informix.o dbdimp.o >dbdattr.o sqltoken.o sqltype.o ix

Re: How do I detect non-select statements after calling $sth->execute()

2002-09-12 Thread Jonathan Leffler
Tim Bunce wrote: > On Tue, Sep 10, 2002 at 01:49:35PM +0200, Roger Perttu wrote: >>Tim Bunce wrote: >>>It has to as it's the "standard" way to check. The DBI docs specifically >>>say "Non-C statements will have C." > >>The pod is a bit unclear about NUM_OF_FIELDS. I know that it returns >>somet

Re: Q on DBI

2002-09-12 Thread Michael A Chase
On Thu, 12 Sep 2002 10:55:57 -0600 "Sterin, Ilya" <[EMAIL PROTECTED]> wrote: > This is because your environment for the DBI module is not set up > correctly. > You must of installed DBI with another perl installation. > > If you used > > perl Makefile.PL > etc > > check > > which perl >

Re: problem with DBD

2002-09-12 Thread Michael A Chase
On Wed, 11 Sep 2002 08:38:26 +0200 (CEST) Seille Amar <[EMAIL PROTECTED]> wrote: > I check the permissions, I have the same configuration > to the oracle client on two computer. But I have the > error only on one. A little more detail would help. -- Mac :}) ** I normally forward private ques

Re: Lost

2002-09-12 Thread Michael A Chase
On Tue, 10 Sep 2002 14:25:57 -0700 John Gedeon <[EMAIL PROTECTED]> wrote: > I am installing a bug reporting tool called Resource Tracker (RT for > short). I finially got all the modules installed however when I try to > install this tool it fails when it tries to connect to the oracle > dat

Re: Problem connecting to Oracle Server

2002-09-12 Thread Michael A Chase
On Mon, 09 Sep 2002 11:44:44 +0530 "Pramod.S.Warrier" <[EMAIL PROTECTED]> wrote: > I am trying to connect to a remote Oracle server using a CGI program > given below. > My problem is that my code works fine on the command prompt. But when i > try to run this program through the broswer its giv

Re: Oracle connectivity problem

2002-09-12 Thread Michael A Chase
On Sat, 7 Sep 2002 15:38:32 +0530 Sridhar Saragu <[EMAIL PROTECTED]> wrote: > We have recently migrated from Oracle 7.3.4 to Oracle8.1.7 on Sun Solaris > 5.8 . > > Now we are working on both databases , we are able to connect to Oracle > 7.3.4 database without any problem, and not able to conn

(Fwd) core dump: PL_ptr_table not set during CLONE (was: DBI makes apache fail)

2002-09-12 Thread Tim Bunce
- Forwarded message from Mark Trubowitsch <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] From: "Mark Trubowitsch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: core dump: PL_ptr_table not set during CLONE (was: DBI makes apache fail) Date: Thu, 12 Sep 2002 14:51:41 -0400 Ti

Re: Connecting to Postgres with DBI

2002-09-12 Thread William McKee
Hardy et al, Thanks for all the suggestions. My "Postgres connection problem" turned out to be an error message from the Mail::Sendmail module. When I transferred my script, I forgot to update the smtp server to the one used on the production site. My next email is to the maintainer of that mo

RE: "fetchrow_hashref" Question

2002-09-12 Thread Rozengurtel, Daniel
Ok, thanx a lot, guys > -Original Message- > From: William R. Mussatto [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, September 12, 2002 1:35 PM > To: Hardy Merrill > Cc: Brian McCain; Rozengurtel, Daniel; [EMAIL PROTECTED] > Subject: Re: "fetchrow_hashref" Question > > Minor improv

Re: "fetchrow_hashref" Question

2002-09-12 Thread William R. Mussatto
Minor improvement: my $there_are_rows=0; while(defined(my %data = $sth->fetchrow_hashref)){ $there_are_rows = 1; use them } On Thu, 12 Sep 2002, Hardy Merrill wrote: > Date: Thu, 12 Sep 2002 12:58:21 -0400 > From: Hardy Merrill <[EMAIL PROTECTED]> > To: Brian McCain <[EMAIL

Re: Connecting to Postgres with DBI

2002-09-12 Thread Hardy Merrill
Postgres experts please chime in - I'm pretty new to Postgres myself. Just to prove a point, I think changing "password" in the "local" and 1st "host" line to "trust" should allow *all* connections from localhost, tcp or not - right? If that worked(don't forget to restart postgres after making t

Re: "fetchrow_hashref" Question

2002-09-12 Thread Hardy Merrill
If I remember right, the only "reliable" way to make sure that rows were returned it to count them. If you only need to know if there were either "none" or "at least 1", then you could do if (defined($sth->fetchrow_hashref)) { $there_are_rows = 1; } else { $there_are_rows

RE: Q on DBI

2002-09-12 Thread Sterin, Ilya
This is because your environment for the DBI module is not set up correctly. You must of installed DBI with another perl installation. If you used perl Makefile.PL etc check which perl and it should give you the perl location. Ilya -Original Message- From: purnima nagar To: [EMA

Re: Connecting to Postgres with DBI

2002-09-12 Thread William McKee
On 12 Sep 2002 at 12:31, Hardy Merrill wrote: > Do your pg_hba.conf and pg_ident.conf files contains any > uncommented lines? I have created the following lines in my pg_hba.conf: local all password host all 127.0.0.1 255.255.255.255

Re: "fetchrow_hashref" Question

2002-09-12 Thread Brian McCain
Check out the docs regarding $sth->rows. (Or, in your case, that would be $join_iedf_ievp_ipdf->rows) Brian McCain PageMasters Internet Group - Original Message - From: "Rozengurtel, Daniel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 9:38 AM Subject: "

Re: MS SQL Issue

2002-09-12 Thread Jeff Seger
Not sure as I am accustomed to Oracle. but that sounds like a similar error message that you get in Oracle when the user you are connecting as doesn't have select permissions on the table you are querying. hth, jeff On Thu, 2002-09-12 at 12:37, Cheryl Duggan wrote: > I have a cgi script that

"fetchrow_hashref" Question

2002-09-12 Thread Rozengurtel, Daniel
Hello All, I have a question about return code from execute statement using "fetchrow_hashref". I need to know if my execute returned anything at all before I start looping thru the hash. In the specs it says: Perform whatever processing is necessary to execute the prepared statement. An undef

MS SQL Issue

2002-09-12 Thread Cheryl Duggan
I have a cgi script that runs a query using DBI::Sybase to connect to SQL Server 2000. This works if I use one DB but not another. Here is the error from the apache logs: DBD::Sybase::st execute failed: Server message number=208 severity=16 state=1 line=1 server=SQLDB1 text=Invalid object name

Re: Connecting to Postgres with DBI

2002-09-12 Thread Hardy Merrill
William McKee [[EMAIL PROTECTED]] wrote: > Hi, > > I'm in the process of converting my www scripts from using Mysql to > PostgreSQL. Currently, I have a mod_perl script which is not being allowed > to connect to the server. I have setup the server to allow TCP/IP > connections via tcpip=1 in pos

Q on DBI

2002-09-12 Thread purnima nagar
hi, I initially had a problem. my perl script was not able to locate DBI package. hence i have include following lines to make DBI recognizable. #!/usr/bin/perl; use lib '/usr/lib/perl5/site_perl/5.005/i586-linux'; use lib '/usr/lib/perl5/site_perl/5.005/i586-linux/Bundle'; use lib '/usr/lib/perl

Re: Connecting to Postgres with DBI

2002-09-12 Thread William McKee
On 12 Sep 2002 at 9:03, Joe Raube wrote: > Do you get an error? > > If so, what is it? Doh. I knew I'd forgotten to include something in that first message. The error I receive is: connect to localhost failed (Connection refused) connect to localhost failed connect to localhost failed (Invali

Connecting to Postgres with DBI

2002-09-12 Thread William McKee
Hi, I'm in the process of converting my www scripts from using Mysql to PostgreSQL. Currently, I have a mod_perl script which is not being allowed to connect to the server. I have setup the server to allow TCP/IP connections via tcpip=1 in postgres.conf. I am able to logon to the server with the

ANNOUNCE: DBD::Chart 0.73

2002-09-12 Thread Dean Arnold
DBD::Chart 0.73 is now available at both CPAN and www.presicient.com/dbdchart. Ths release fixes a number of bugs introduced in 0.72: - fixed scaling of 3-D barcharts - added axis labels for 3-D barchart - improved rendering of single point line/point graphs and barcharts -

Re: "Relocation error"

2002-09-12 Thread Rich DeSimone
Ok so you are suggesting an "apt-get remove libdbd-mysql-perl" then an "apt-get install libdbd-mysql-perl"? Rich - Original Message - From: "Waldemar Zurowski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 4:32 AM Subject: Re: "Relocation error" > On We

RE: (Fwd) Compile problem with DBD-Oracle-1.12

2002-09-12 Thread Bjorn.Naessens
Getting further and further here : I changed the /lib/crt0_64.o file with the /lib/crt0.o file in the Makefile. But now i get some weird messages on my errors : Running Mkbootstrap for DBD::Oracle () chmod 644 Oracle.bs LD_RUN_PATH="/softw/app/oracle/producti/901/lib32" ld -o

RE: (Fwd) Compile problem with DBD-Oracle-1.12

2002-09-12 Thread Bjorn.Naessens
Nice solution, but now i get another problem : LD_RUN_PATH="/softw/app/oracle/producti/901/lib32" ld -o blib/arch/auto/DBD/Oracle/Oracle.so -bhalt:4 -bM:SRE -bI:/usr/opt/perl5/lib/5.00503/aix/CORE/perl.exp -bE:Oracle.exp -b noentry -lc Oracle.o dbdimp.o oci7.o oci8.o /softw/app/oracl

Re: (Fwd) Compile problem with DBD-Oracle-1.12

2002-09-12 Thread James D. White
The problem looks like Perl and DBI run in 32-bit mode, but Oracle 9i installs as 64-bit. (Oracle 8 installed as 32-bit.) I saved the following email with the solution in my bag of tricks. This message was for Solaris, which is what I am using. A week or so ago, it also worked for hpux. Hopefu

Re: "Relocation error"

2002-09-12 Thread Waldemar Zurowski
On Wed, 11 Sep 2002 13:57:25 -0400 "Rich DeSimone" <[EMAIL PROTECTED]> wrote: > I thought 5.8.0 was stable? Do you suggest I use an earlier version? No. I was thinking about Debian. I > I tried "apt-get install libdbd-mysql-perl" and it says I have the newest > version. Then look again at th

UPDATE: installation of DBD::Oracle 1.12 on ibm aix 64bit

2002-09-12 Thread Bjorn.Naessens
New info : I decided to copy an existing perl, DBI, DBD installation from another server where oracle 9.0.1 was already installed ( 64 bit ) and where perl did work. Then I recompiled DBI-1.20 and DBD-ORACLE-1.12 without problems on the server. However I'm back to my first problem now. The pro