RE: Problem with perl 5.8.8 with Oracle 9.0

2006-03-24 Thread Ron Savage
On Fri, 24 Mar 2006 08:37:37 -0700, Reidy, Ron wrote: Hi Ron > Google is my friend. I can be your friend also: > http://codecomments.com/PERL_DBI/message824574.html http://codecomments.com/ is unreachable. Any other source? -- Cheers Ron Savage, [EMAIL PROTECTED] on 25/03/2006 http://savage.ne

Re: Can't trap Pg warnings

2006-03-24 Thread tlm
On 3/24/06, Joe Slagel <[EMAIL PROTECTED]> wrote: > > Looks like prior to DBD::Pg 1.31 these warning messages where sent to > stderr and not via perl's warning mechanism. > > http://www.mail-archive.com/dbi-announce@perl.org/msg00170.html Yep, that was it. (I'm amazed that our supposedly "brand-

Re: Can't trap Pg warnings

2006-03-24 Thread Joe Slagel
Looks like prior to DBD::Pg 1.31 these warning messages where sent to stderr and not via perl's warning mechanism. http://www.mail-archive.com/dbi-announce@perl.org/msg00170.html On Fri, 2006-03-24 at 07:19 -0500, tlm wrote: > On 3/24/06, Alexander Foken <[EMAIL PROTECTED]> wrote: > > > > Ripped

RE: Problem with perl 5.8.8 with Oracle 9.0

2006-03-24 Thread Reidy, Ron
Google is my friend. I can be your friend also: http://codecomments.com/PERL_DBI/message824574.html Read the comment from Andy Hassal. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Kedar Joshi -X (kedajosh - Infosys at Cisco) [mailto:[EMAIL PROTECTED] Sent: Frida

Re: DBI::ODBC in a web application

2006-03-24 Thread Tom Schindl
Well I think that you problem is a environment problem as already outlined. If you need to have access to ENV-Variables you must forward them explicitly to the cgi because they are not passed by default because of security risks. For more information see: http://httpd.apache.org/docs/2.0/mod/mod_e

Re: Problem with perl 5.8.8 with Oracle 9.0

2006-03-24 Thread John Scoles
This is can be a number of things but it is definitely a configuration problem of some sort as Oracle has some environment variables that are critical, so check your LD_LIBRARY_PATH, ORACLE_HOME, and NLS_LANG paths These values may not be set for the user attempting to run the app. Check with yo

problem using table_info and column_info with DBD::Proxy

2006-03-24 Thread Allan Dyer
I think I've found a problem with DBD::Proxy - table_info and column_info do not work. m using DBI 1.50, perl 5.8.6, mysql 4.1.7, Linux kernel 2.6.15 I'm trying to access a mysql database on one machine from a webserver on another machine. I was able to do simple SELECT queries, but I ran into

Re: Can't trap Pg warnings

2006-03-24 Thread tlm
On 3/24/06, Alexander Foken <[EMAIL PROTECTED]> wrote: > > Ripped out of some of my code working with DBD::Pg: > ># DBI->connect() here >$SIG{'__WARN__'}=sub { ># Don't use REs (//) here, you would change some special variables! >warn @_ unless substr($_[0],0,7) eq 'NOTICE:'

Problem with perl 5.8.8 with Oracle 9.0

2006-03-24 Thread Kedar Joshi -X \(kedajosh - Infosys at Cisco\)
Hi Tim, I have a problem with perl operating with DBD-Oracle. The error i get is as follows - DBI connect('edwtest','i2_read',...) failed: ERROR OCINlsEnvironmentVariableGet( OCI_NLS_CHARSET_ID) Check ORACLE_HOME and NLS settings etc. at f:\tkprod\bkscrip t\perlscript\i2lutils.pl line 2372 Datab