DBI DBD-Oracle connection failure woth ORA-12705
- From: gavin.s.williams@xxxxxxxxxxxxxx (Gavin W)
- Date: Fri, 26 Aug 2005 09:02:39 +0100
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
- Prev by Date: Re: MySQL 4.1+ Password Incompatibility
- Next by Date: RE: Connect failure: OCIEnvNlsCreate (check ORACLE_HOME and NLSsettings etc.) - SOLVED
- Previous by thread: DBD: db_login/SQLConnect err=-1 with unixODBC/FreeTDS on Linux
- Next by thread: RE: DBI DBD-Oracle connection failure woth ORA-12705
- Index(es):
Relevant Pages
|
|
