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