Metalink not 158654.1 ----------------- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message----- From: Gavin W [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 2:03 AM To: [email protected] 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.
