Re: DBI/DBD question

2010-04-28 Thread m. allan noah
On Tue, Apr 27, 2010 at 2:17 PM, Royce Miller royce...@pacbell.net wrote: The interactive stuff works fine on the new system, but the web pages fail. Sounds like the informix client libs are either not accessible to the apache/cgi user, or the environment variables pointing to them are missing

Re: [Fwd: Re: failed: ERROR OCIEnvNlsCreate. Check (everything)]

2010-04-08 Thread m. allan noah
You might also wish to try using Env::C. I have had some weird cases where the perl %ENV looked ok, but the 'actual' environment was different. allan On Thu, Apr 8, 2010 at 2:51 PM, Sven Miller ngdvakigyot...@gmail.com wrote: NLS_LANG = en_GB.UTF-8 As I understand it, UTF-8 is not a valid

Re: parameter issues in DBD:Oracle

2010-03-26 Thread m. allan noah
You cannot pack a comma separated list into a single ?, because they will be wrapped together in one set of quotes. Use multiple ? in your 'in()' clause, and send each item individually into execute(). allan On Fri, Mar 26, 2010 at 2:01 PM, Bruce Johnson john...@pharmacy.arizona.edu wrote: I'm

Re: DBD::mysql on OSX 10.6 install for remote access???

2010-01-25 Thread m. allan noah
you must install at least some sort of mysql client libraries and development headers on the system. allan On Sun, Jan 24, 2010 at 1:54 PM, ivowel ivo...@gmail.com wrote: I am running the standard OSX perl distribution, which is 5.10.0 (no kidding).  I believes it comes with DBI installed,

Re: DBD::mysql on OSX 10.6 install for remote access???

2010-01-25 Thread m. allan noah
Note that mysql-client is often a separate package from mysql-server. allan On Mon, Jan 25, 2010 at 9:10 AM, ivo welch ivo.we...@gmail.com wrote: thanks.  I presume this means defacto that I shall need to install mysql on any system on which I want to write a perl program that requires remote

Re: Cant connect to mysql database !

2010-01-20 Thread m. allan noah
I think you mean DBI-connect(, not DBI::connect-( allan On Wed, Jan 20, 2010 at 5:56 AM, Pooja Sohni pso...@google.com wrote: Can't connect to data source '' because I can't work out what driver to use (it doesn't seem to contain a 'dbi:driver:' prefix and the DBI_DRIVER env var is not  

Re: Missing informix error messages

2010-01-19 Thread m. allan noah
On Thu, Jan 14, 2010 at 7:41 PM, Jonathan Leffler jonathan.leff...@gmail.com wrote: On Thu, Jan 14, 2010 at 8:49 AM, m. allan noah kitno...@gmail.com wrote: I have a problem with some fastcgi scripts which use DBD::Informix. I trust this is DBD::Informix 2008.0513 and not some earlier version

Re: Missing informix error messages

2010-01-19 Thread m. allan noah
On Tue, Jan 19, 2010 at 11:06 AM, m. allan noah kitno...@gmail.com wrote: On Thu, Jan 14, 2010 at 7:41 PM, Jonathan Leffler jonathan.leff...@gmail.com wrote: On Thu, Jan 14, 2010 at 8:49 AM, m. allan noah kitno...@gmail.com wrote: I have a problem with some fastcgi scripts which use DBD

Missing informix error messages

2010-01-14 Thread m. allan noah
I have a problem with some fastcgi scripts which use DBD::Informix. Fastcgi is like regular cgi, except the script does not exit after the request is complete, it loops back to the beginning, and waits for a new request. This significantly improves performance for scripts with large startup

Re: strange bug with DBI, Sybase, sendmail and mod_perl

2010-01-06 Thread m. allan noah
perhaps you should set InactiveDestroy true on your handle before you open the pipe to sendmail? allan On Wed, Jan 6, 2010 at 2:50 PM, Jonathan Swartz swa...@pobox.com wrote: This is one of the most bizarre and specific bugs I've ever seen. I've minimized it as much as I can. Please bear with

Re: DBI.pm package not found

2009-12-10 Thread m. allan noah
/oracle/app/oracle/product/ vs /app/oracle/product/ maybe? allan On Thu, Dec 10, 2009 at 6:00 AM, Kallol Chakraborty kal...@aircel.co.in wrote: Hi,                I am having DBI.pm package in /oracle/app/oracle/product/10.2.0/in-dwh/perl/lib/site_perl/5.8.3/i686-linux-thread-multi ,

Re: Howto hard code ORACLE_HOME in DBD::Oracle Module

2009-11-23 Thread m. allan noah
On Mon, Nov 23, 2009 at 3:03 PM, Bruce Johnson john...@pharmacy.arizona.edu wrote: On Nov 22, 2009, at 9:46 AM, Harald Falkenberg wrote: Hello, due to migration a bulk of perl scripts to another web server, I need to prepare perl module DBD::Oracle to run properly against oracle databases

Re: DBD::DB2 without local instance?

2009-11-20 Thread m. allan noah
Praveen, I have just built, installed, and tested DBD::DB2 with the first 'ODBC and CLI' driver you suggested, many thanks for your support! But now I wonder, what advantage or difference will this larger 'server driver package' give me? allan On Thu, Nov 19, 2009 at 11:14 AM, Praveen

Re: DBD::DB2 without local instance?

2009-11-18 Thread m. allan noah
On Wed, Nov 18, 2009 at 3:53 AM, Praveen praveen...@in.ibm.com wrote: Hi Allan, Check if your DB2INSTANCE environment variable is set correctly to the instance name to over come this error. I don't have an instance on the client machine, do i need the one on the server? Given that you have

DBD::Informix compile problem solved

2009-11-18 Thread m. allan noah
I had some problem installing DBD::Informix on a particular HPUX 11.31 host, though it worked on other supposedly identical machines. I would document the solution for the archives/google: The driver builds, but most tests fail. The error message is interesting, the linker is complaining about

DBD::DB2 without local instance?

2009-11-17 Thread m. allan noah
Folks- Trying to build a 'lightweight' DB2 client on HPUX 11.32 with perl 5.8.8, with IBM z-series linux as the server. I have the client libs in /opt/IBM/db2/V9.1, and have the DB2_HOME var set to this directory, and DBD::DB2 builds and installs correctly. I have not installed a new user or an