Perl5.8 Oracle DBI connects failing

------=_Part_33249_7961932.1163733683353
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,
I am unable to connect to my oracle database I am getting the following
errors..


" DBI connect Failed: connect Failing because of ERROR OCIEnvNlsCreate.
Check ORACLE_HOME env var, NLS settings, permissions, etc."

I stumble into this when I try to execute

"$dbh->selectall_arrayref( $sql )"

I am running Perl5.8 on Red Hat Enterprise Edition 3 and using DBD Oracle
1.17, DBI 1.46 trying to access Oracle 10g

I am not sure which module was compiled against which one..?

any insight into whats happenign here can be great.


Thanks
--

-vmbharathi

I can resist anything but temptation

------=_Part_33249_7961932.1163733683353--
vmbharathi [ Fr, 17 November 2006 04:21 ] [ ID #1539934 ]

Re: Perl5.8 Oracle DBI connects failing

Looks like DBD::Oracle is not finding the correct OCI files. Have you
updated you Oracle DB or client lately. If so you will have to recompile
DBD::Oracle to run with it.

""Bharathi Masilamani"" <vmbharathi [at] gmail.com> wrote in message
news:6a9117130611161921x715151b9hd18d8fbac8ecefd2 [at] mail.gmail .com...
> Hi,
> I am unable to connect to my oracle database I am getting the following
> errors..
>
>
> " DBI connect Failed: connect Failing because of ERROR OCIEnvNlsCreate.
> Check ORACLE_HOME env var, NLS settings, permissions, etc."
>
> I stumble into this when I try to execute
>
> "$dbh->selectall_arrayref( $sql )"
>
> I am running Perl5.8 on Red Hat Enterprise Edition 3 and using DBD Oracle
> 1.17, DBI 1.46 trying to access Oracle 10g
>
> I am not sure which module was compiled against which one..?
>
> any insight into whats happenign here can be great.
>
>
> Thanks
> --
>
> -vmbharathi
>
> I can resist anything but temptation
>
scoles [ Mo, 20 November 2006 13:12 ] [ ID #1542438 ]
Perl » perl.dbi.users » Perl5.8 Oracle DBI connects failing

Vorheriges Thema: Another (free) db schema drawing tool (for Oracle): Schemester
Nächstes Thema: DBD Oracle module