RE: DBI DBD-Oracle connection failure woth ORA-12705

Metalink not 158654.1

-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.


-----Original Message-----
From: Gavin W [mailto:gavin.s.williams@xxxxxxxxxxxxxx]
Sent: Friday, August 26, 2005 2:03 AM
To: dbi-users@xxxxxxxx
Subject: DBI DBD-Oracle connection failure woth ORA-12705


Environment = Windows XP, perl 5.6 (activestate)



I recently upgraded my DBI module to 1.32

And DBD-Oracle to 1.16



I have an Oracle 9 database on my PC, and have been connecting to it using
DBI with no problems.



On upgrading to the above versions (I think the prior DBD was 1.12)

My connection no longer works



Here is the code which has not changed

# $!perl -w





use strict;

use DBI;





DBI->trace(2,"my_trace.txt");

my %attr = (RaiseError => 0, AutoCommit =>1);

my $dbh = DBI->connect("dbi:Oracle:host=127.0.0.1;sid=GAV", 'tdf', 'bike',
\%attr)

or die "Failed to connect to database: $DBI::errstr";

my $sth = $dbh->prepare("

SELECT distinct (owner)

FROM tdf_results

" );

$sth->execute();









Here is the error





C:\databases\perl\eg>perl tdftest4.pl

DBI connect('host=127.0.0.1;sid=GAV','tdf',...) failed: ORA-12705: invalid
or unknown NLS parameter

value specified (DBD ERROR: OCISessionBegin) at tdftest4.pl line 10

Failed to connect to database: ORA-12705: invalid or unknown NLS parameter
value specified (DBD ERRO

R: OCISessionBegin) at tdftest4.pl line 10.



Is this a known issue, or am I unlucky? Can anyone help, or point me in the
right direction?



Thanks



Gavin


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

.

Relevant Pages

  • RE: :Oracle - with ora10g oci.dll
    ... I agree it's not a DBD or DBI error. ... your connection descriptor seems suspect: ... how to get to our nameservers. ... 10g installation is really just a few files in the /perl/bin directory. ...
    (perl.dbi.users)
  • Re: Mysql::Simple?
    ... GetOptions passthrough to interpret standard mysql options, ... it work with standard DBI environment variables, ... This way I find it easy to set up and wangle connection details. ... > Fetches the next row of data and returns a reference to an array holding the ...
    (comp.lang.perl.modules)
  • Re: DBI v2 - The Plan and How You Can Help
    ... $sth1.prepare; # always with connection, even if DBD doesn't use it $sth1.execute; # always with connection ... method the arguments you would have given to prepare, and you invoke prepareon the result with no arguments; each DBD would decide for itself how the work is divided between compileand preparewith the limitation that compileis not allowed to access the database; ideally the DBD would place as much work there as is possible, which would vary between Oracle/Pg/etc. ... designed to effectively support wrapper modules, the wrapper modules would also be altered from their current DBI-1-geared designs to accomodate DBI-2. ... module just because a new driver came into existence whose name has not yet been hard-coded into DBI. ...
    (perl.dbi.users)
  • Re: DBD::DB2 question need an example
    ... I've installed the latest Active state Perl, the latest DBI and DBD::DB2 ... but I can't make the connection work...... ... connecting to the database ...
    (perl.dbi.users)
  • system() return code always -1 after DBI/DBD local connection
    ... I am attempting to package a common Perl v5.8.6 + DBI ... Oracle 10g client and appears to be able to connect OK ... After making a connection with DBI, ...
    (perl.dbi.users)