oracle OCI.dll NLS error on connect

Did anyone figure this one out? I am having the same issue, but don't
see a response to this initial posting.

I have oracle 8.1.7 client installed and the following:

Windows Server 2003
ActivePerl 5.8.7 build 813
DBI 1.49
DBD-Oracle 1.16

BTW, is anyone else having issues with PPM? Seems like the last few
releases have had bugs.... it's getting frustrating?

L

***************

oracle OCI.dll NLS error on connect
listmail
Mon, 07 Nov 2005 09:13:55 -0800
I get the following error when connecting to an 8i oracle database from=20
workstations with the Oracle 8i client installed or if their Oracle=20
Home selector is set to the 8i home. If the workstations only have the=20
Oracle 9i client installed or if the Oracle Home selector is set to=20
the 9i home, then this error does not occur. From the looks of the=20
error my guess is that the (unpatched?) 8i OCI.dll doesn't contain a=20
OCINlsEnvironmentVariableGet function/subroutine.

Error dialog:
The procedure entry point OCINlsEnvironmentVariableGet could not be=20
located in the dynamic link library OCI.dll

For those of you that may have seen this, is there a switch I can use=20
within the DBI connect call or perhaps an environment variable that I=20
can set within the perl code to work around this?


Windows XP and NT
ActivePerl 5.8.7 build 813 (modules installed using ppm)
DBI 1.48
DBD-Oracle 1.16

Re: oracle OCI.dll NLS error on connect

Sorry, but I do not remember if I had worked around this by setting NLS
environment variable(s) in Windows
on each client or not. The situation was painful enough to convince me
to upgrade all my (Perl) client machines to
the 9iR2 client (or technically, at least a bare minimum install to get
the newer Net8 install). I haven't had any issues
accessing my 8i databases using DBD-Oracle 1.16 and the 9iR2 client.



Mitchell, Louise M wrote:

>Did anyone figure this one out? I am having the same issue, but don't
>see a response to this initial posting.
>
>I have oracle 8.1.7 client installed and the following:
>
>Windows Server 2003
>ActivePerl 5.8.7 build 813
>DBI 1.49
>DBD-Oracle 1.16
>
>BTW, is anyone else having issues with PPM? Seems like the last few
>releases have had bugs.... it's getting frustrating?
>
>L
>
>***************
>
>oracle OCI.dll NLS error on connect
>listmail
>Mon, 07 Nov 2005 09:13:55 -0800
>I get the following error when connecting to an 8i oracle database from
>workstations with the Oracle 8i client installed or if their Oracle
>Home selector is set to the 8i home. If the workstations only have the
>Oracle 9i client installed or if the Oracle Home selector is set to
>the 9i home, then this error does not occur. From the looks of the
>error my guess is that the (unpatched?) 8i OCI.dll doesn't contain a
>OCINlsEnvironmentVariableGet function/subroutine.
>
>Error dialog:
>The procedure entry point OCINlsEnvironmentVariableGet could not be
>located in the dynamic link library OCI.dll
>
>For those of you that may have seen this, is there a switch I can use
>within the DBI connect call or perhaps an environment variable that I
>can set within the perl code to work around this?
>
>
>Windows XP and NT
>ActivePerl 5.8.7 build 813 (modules installed using ppm)
>DBI 1.48
>DBD-Oracle 1.16
>
>
>