perl-oracle connection error

2004-02-21 Thread ram kumar
This is the script: #! /usr/bin/perl print Content-type: text/html, \n\n; print HTML, \n; print HEAD; print TITLE Testing Team ListTITLE, \n; print /HEAD, \n; print BODY; use CGI::Carp qw(fatalsToBrowser); use DBI; use strict; my $dbh = DBI-connect('dbi:Oracle:','scott','tiger',{RaiseError =

Re: perl-oracle connection error

2004-02-21 Thread David N Murray
Apache (assuming you are using Apache, you didn't indicate) doesn't have ORACLE_HOME set. On Feb 21, ram kumar scribed: This is the script: #! /usr/bin/perl # This should fix it: $ENV{ORACLE_HOME} = '/opt/ora9/product/9.2'; # but there's probably a better way... print Content-type:

(Fwd) Perl compiler and DBI

2004-02-21 Thread Tim Bunce
- Forwarded message from [EMAIL PROTECTED] - Delivered-To: [EMAIL PROTECTED] Subject: Perl compiler and DBI Date: Fri, 20 Feb 2004 17:55:18 -0500 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] X-SMType: Regular X-SMRef: N1-Wms7Ak9t Hi Tim, Sorry to bug you as

Re: (Fwd) Perl compiler and DBI

2004-02-21 Thread Dean Arnold
Hi Tim, Sorry to bug you as I know you're very busy. I've searched high and low, and found no answers as yet. So... I have some code which runs great as a script but does not survive when compiled with ActiveState's perlapp on Win32. This test code below normally pulls up all my

ORACLE NEWBIE PROBLEMS: ORACLE DOES NOT RECOGNIZE AN EXISTING TABLE!

2004-02-21 Thread moka
Hi, my first experience with Oracle: First, I connect to the database and get all table names: opened Oracle with MYDUMMY1 . table :PATIENTS dbh=DBI::db=HASH(0x1756dc) then try to do a SELECT FROM that table and get: DBD::Oracle::db prepare failed: ORA-00942: table or view does not

Re: DBI::Shell still failing to install under Fedora Core 1

2004-02-21 Thread Scott R. Godin
Scott R. Godin wrote: t/coredubious Test returned status 0 (wstat 139, 0x8b) Scalar found where operator expected at (eval 153) line 1, near 'int' $__val (Missing operator before $__val?) after all the subtests completed successfully t/funcskipped

Re: DBI::Shell still failing to install under Fedora Core 1

2004-02-21 Thread Jeff Zucker
Scott R. Godin wrote: Scott R. Godin wrote: t/coredubious Not one response since Feb 9th? what's going on here? You mean the Feb. 9th that happend less than two weeks ago? Did you submit a patch? If not, what is going on is probably that the module's author a) has a life and/or

RE: Date/time conversion with DBD::ODBC and Access database

2004-02-21 Thread Jeff Urlwin
I posted this last week but didn't get a single reply. I thought someone could at least give me a clue about where to look. How about google. With a little work (10 minutes), I found: Format([Date of Birth], d ) AS [formatted date] Which would give me a clue that I could change

Re: DBI::Shell still failing to install under Fedora Core 1

2004-02-21 Thread Scott R. Godin
Jeff Zucker wrote: t/coredubious Not one response since Feb 9th? what's going on here? You mean the Feb. 9th that happend less than two weeks ago? Did you submit a patch? If not, what is going on is probably that the module's author a) has a life and/or b) is busy. :-) *chuckle*

Re: can you help

2004-02-21 Thread Jared Still
It is an issue with 5.8.0. I don't know the details, but upgrading to 5.8.2 corrected the problem for me. Jared On Thu, 2004-02-05 at 13:15, Jeff Zucker wrote: Bryson, Stewart wrote: I appreciate your help Jeff. The pragma you specified does not correct the issue I'm getting the

Re: Date/time conversion with DBD::ODBC and Access database

2004-02-21 Thread Jared Still
You could convert the date with Date::Manip, a very useful package for such things. Providing you don't find a direct method in Access. On Fri, 2004-02-20 at 20:52, Dennis M. Gray wrote: I posted this last week but didn't get a single reply. I thought someone could at least give me a clue

Re: getting rid of the Issuing rollback() warning

2004-02-21 Thread Jared Still
I find it difficult enough to jump through hoops, much less hooks. ;) On Wed, 2004-02-11 at 05:15, Andrew Pimlott wrote: On Wed, Feb 11, 2004 at 09:35:59AM +, Tim Bunce wrote: For mod_perl you can register a suitable callback. I am using mod_perl, and that's what I mean about having to

RE: Performance related question

2004-02-21 Thread Jared Still
Improving the SQL is always a performance boost. Parsing is a big part of the performance hit in many applications that are written with little thought to the database performance. To reaffirm what a previous respondent has said, significant performance increases will be seen by only