Error writing to double using ODBC

2005-09-20 Thread Wim Livens
I'm having trouble writing to columns of type DOUBLE using ODBC (to Pervasive.SQL) $dbh = DBI-connect('dbi:ODBC:DEMODATA','','',{RaiseError = 1, PrintError =1}) or die $DBI::errstr; $sth=$dbh-prepare(update mytable set mycolumn=? where id=123) || die $DBI::errstr; $value=3/2;

Re: DB2 Err Handling

2005-09-20 Thread Dan Scott
Tim Bunce wrote: On Fri, Sep 02, 2005 at 05:37:57PM -0500, johnn wrote: Capacio, Paula J wrote: my $stmt = 'select count(*) from sysibm.badTblnm '; my $sth = $dbh-prepare($stmt) or die Prepare Failed\n; DBD::DB2 doesn't seem to return false values for failures. If that's true then

Perl-Oracle DBI module

2005-09-20 Thread Trivedi, Dhirendra
Hi, Trying to install Oracle Driver for Perl I get the error message UNKNOWN OCI STATUS 24322) OCIInitialize. Check ORACLE_HOME and NLS settings etc. at t/general.t line 21 Are you able to advise a work around for this ? t/base..ok t/general...DBI-connect failed:

Re: Perl-Oracle DBI module

2005-09-20 Thread Jonathan Leffler
So, which part of the README file did you have difficulty understanding? On 9/20/05, Trivedi, Dhirendra [EMAIL PROTECTED] wrote: Trying to install Oracle Driver for Perl I get the error message UNKNOWN OCI STATUS 24322) OCIInitialize. Check ORACLE_HOME and NLS settings etc. at t/general.t

RE: Perl-Oracle DBI module

2005-09-20 Thread Mitchell, Louise M
Oracle has some environment variables that are critical, such as ORACLE_HOME, NLS_LANG, etc. It appears that these are not set for the user that is doing the install. Check with your Oracle DBA if you're not familiar with these. L -Original Message- From: Trivedi, Dhirendra