RE: Insights into DBI->connect differences

2006-02-15 Thread Reidy, Ron
Sorry, pushed the send button too fast ... You also should set your oracle environment using the shell script oraenv. There are many other env vars that need to be set in order for the DBD to load and function correctly. Again, see the link I sent earlier and set for oraenv. -Original Messa

RE: Insights into DBI->connect differences

2006-02-15 Thread Reidy, Ron
The Oracle error docs are your friend: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96525.pdf -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Capacio, Paula J [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 15, 2006 1:37 PM To: dbi-users@perl.org

Re: Insights into DBI->connect differences

2006-02-15 Thread Louis Gonzales
Capacio, Paula J wrote: Hello, I'm hoping someone can explain why one of these connect statements work and the other doesn't. The script sets environment values as such: $ENV{ORACLE_HOME} = "/usr/oracle/product/8.1.7_64"; $ENV{ORACLE_SID} = $db_alias;#$db_alias passed to script via $ARGV[1]

Insights into DBI->connect differences

2006-02-15 Thread Capacio, Paula J
Hello, I'm hoping someone can explain why one of these connect statements work and the other doesn't. The script sets environment values as such: $ENV{ORACLE_HOME} = "/usr/oracle/product/8.1.7_64"; $ENV{ORACLE_SID} = $db_alias;#$db_alias passed to script via $ARGV[1] my $dbh; if ($method =~ /2/

Re: Some progress on Strange selectall_hashref/fetchall_hashref problem with DBD::mysql

2006-02-15 Thread Martin J. Evans
On 15-Feb-2006 Tim Bunce wrote: > On Tue, Feb 14, 2006 at 06:16:30PM -, Martin J. Evans wrote: >> Regarding my posting with a problem using DBI 1.50 and DBD:mysql 3.0002_4 >> (reprinted below) I wonder if someone who knows DBI and DBD::mysql better >> than I can point me in the right direction

Re: Some progress on Strange selectall_hashref/fetchall_hashref problem with DBD::mysql

2006-02-15 Thread Tim Bunce
On Tue, Feb 14, 2006 at 06:16:30PM -, Martin J. Evans wrote: > Regarding my posting with a problem using DBI 1.50 and DBD:mysql 3.0002_4 > (reprinted below) I wonder if someone who knows DBI and DBD::mysql better > than I can point me in the right direction. I've discovered if I make a small >