RE: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Howard, Chris
And tnsnames.ora under each ORACLE_HOME works good using sqlplus or other tools, yes? From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com] Sent: Monday, August 08, 2016 9:37 AM To: Howard, Chris; Nelson, Erick; mohammed.must...@wipro.com; dbi-users@perl.org Subject: RE: ORA

RE: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Howard, Chris
ORACLE_HOME not defined correctly? (I would test by printing out all ENV from within script) -Original Message- From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com] Sent: Monday, August 08, 2016 5:38 AM To: Nelson, Erick; mohammed.must...@wipro.com;

RE: suppress quoting in prepared sql

2016-04-05 Thread Howard, Chris
Insert "in" values in a table. Run the query with a sub-select or join against the table. -Original Message- From: Paul DuBois [mailto:p...@snake.net] Sent: Tuesday, April 05, 2016 11:37 AM To: Vaughan, Mark Cc: Bruce Ferrell; dbi-users@perl.org Subject: Re: suppress quoting in

RE: help with odd DBI perpare/execute errors

2015-06-03 Thread Howard, Chris
Can you post a copy of your prepare statement? -Original Message- From: William Bulley [mailto:w...@umich.edu] Sent: Wednesday, June 03, 2015 7:57 AM To: Martin J. Evans Cc: dbi-users@perl.org Subject: Re: help with odd DBI perpare/execute errors According to Martin J. Evans

RE: help with odd DBI perpare/execute errors

2015-06-03 Thread Howard, Chris
cat scriptname | od -bc | more -Original Message- From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu] Sent: Wednesday, June 03, 2015 11:13 AM To: William Bulley Cc: dbi-users@perl.org Subject: Re: help with odd DBI perpare/execute errors On Jun 3, 2015, at 9:44 AM, William

time of prepare ?

2012-02-24 Thread Howard, Chris
I have a DBD::Oracle script which needs some help. I have other DBD::Oracle scripts working ok, so I think my installation is fine. This particular script attempts to integrate into a larger application's job security features. The application vendor supplied me with some wrapped procedures

RE: time of prepare - solved

2012-02-24 Thread Howard, Chris
: Howard, Chris [mailto:howa...@prpa.org] Sent: Friday, February 24, 2012 1:14 PM To: 'dbi-users@perl.org' Subject: time of prepare ? I have a DBD::Oracle script which needs some help. I have other DBD::Oracle scripts working ok, so I think my installation is fine. This particular script attempts

Oracle DBI on trusted hpux

2012-02-07 Thread Howard, Chris
kind DBI users, In order to get some security features that my users are asking for, it looks like I will need to implement trusted mode on our HP-UX servers. Will that have any impact on Perl/DBI scripts that run correctly in our current, untrusted mode environment? We are using Oracle Wallet

external password store with perl DBI and CGI

2010-11-11 Thread Howard, Chris
I have a perl CGI script that uses DBI, connects to a 10g database and does some simple stuff. It works. I want to use Oracle Wallet so that my script does not have the text of the username/password wired in. This is on HP-UX and I am using Apache httpd. I have modified the Apache

RE: external password store with perl DBI and CGI

2010-11-11 Thread Howard, Chris
Found! I needed to define $ENV{'HOME'} in my script prior to the DBI connect so that the .sqlnet.ora file could be located Thanks! -Original Message- From: Howard, Chris [mailto:howa...@prpa.org] Sent: Thursday, November 11, 2010 10:15 AM To: dbi-users@perl.org Subject: external

RE: sql*net message from client hang

2010-07-08 Thread Howard, Chris
If it always stops at the same place, it makes me think of a resource problem, something like a quota? I don't remember of there are select quotas. Does it do the same if run as sysdba or some other well-endowed database user? -Original Message- From: Dan [mailto:dkele...@gmail.com]

RE: Problems with external password store.

2010-04-21 Thread Howard, Chris
...@pythian.com] Sent: Tuesday, April 20, 2010 8:38 AM To: Howard, Chris Cc: John Scoles; dbi-users@perl.org Subject: Re: Problems with external password store. Yes you can find out with ORA_OCI use DBD::Oracle qw(:ora_types); print DBD::Oracle::ORA_OCI I think

RE: Problems with external password store.

2010-04-21 Thread Howard, Chris
I wasn't too clear. The scripts give error message complaints, but they actually do work. Chris -Original Message- From: Howard, Chris [mailto:howa...@prpa.org] Sent: Wednesday, April 21, 2010 12:39 PM To: John Scoles Cc: John Scoles; dbi-users@perl.org Subject: RE: Problems

RE: Problems with external password store.

2010-04-21 Thread Howard, Chris
-Original Message- From: John Scoles [mailto:sco...@pythian.com] Sent: Wednesday, April 21, 2010 12:59 PM To: Howard, Chris Cc: John Scoles; dbi-users@perl.org Subject: Re: Problems with external password store. Howard, Chris wrote: Can you send the error message just for fun

RE: Problems with external password store.

2010-04-20 Thread Howard, Chris
Message- From: John Scoles [mailto:byter...@hotmail.com] Sent: Tuesday, April 20, 2010 6:51 AM To: Howard, Chris; dbi-users@perl.org Subject: RE: Problems with external password store. If you are trying to connect to both at the same time using two different wallets I am afraid you are out

RE: Problems with external password store.

2010-04-20 Thread Howard, Chris
:38 AM To: Howard, Chris Cc: John Scoles; dbi-users@perl.org Subject: Re: Problems with external password store. Yes you can find out with ORA_OCI use DBD::Oracle qw(:ora_types); print DBD::Oracle::ORA_OCI I think will work Cheers John Only one wallet

Problems with external password store.

2010-04-19 Thread Howard, Chris
I have two database servers, there are some differences between the way that perl dbd/dbi is installed on these machines, but both are running HP-UX and Oracle 10g. I am trying to use external password store (oracle wallet) to change scripts with embedded login information to be more secure. On

RE: Problems with external password store.

2010-04-19 Thread Howard, Chris
TNS_ADMIN is not set in either case. that's an alternative to the local $HOME/.sqlnet.ora file? -Original Message- From: Michael Broadwater [mailto:mbroad...@yahoo.com] Sent: Monday, April 19, 2010 10:57 AM To: Howard, Chris; dbi-users@perl.org Subject: Re: Problems with external

RE: Problems with external password store.

2010-04-19 Thread Howard, Chris
Yes. -Original Message- From: Michael Broadwater [mailto:mbroad...@yahoo.com] Sent: Monday, April 19, 2010 11:43 AM To: Howard, Chris; dbi-users@perl.org Subject: Re: Problems with external password store. Does the perl script work without using the wallet? -Mike

RE: Troubles on HP-UX with DBD:Oracle

2002-04-18 Thread Howard, Chris
Rebuilding all current versions under HP-UX 11.0 appears to have solved the problem! -Original Message- From: Howard, Chris Sent: Wednesday, April 17, 2002 3:38 PM To: '[EMAIL PROTECTED]' Subject: Troubles on HP-UX with DBD:Oracle Hi, Thanks for your time in looking this over. I

Troubles on HP-UX with DBD:Oracle

2002-04-17 Thread Howard, Chris
Hi, Thanks for your time in looking this over. I currently have DBI, DBD:Oracle running fine talking to my 7.3.4 databases. This is on an HP-UX 11.0 platform. But, as everyone knows, 7.3.4 is ancient history and the move is on toward 8.1.7 (we tend to lag behind the times). I installed an