Hi,
I just install DBD::ORACLE in PERL, and try to connect to my ORACLE DB.
However, I receive the following error message. Does anyone know how to
resolve this problem? Thanks
"The procedure entry point OCINlsEnvironmentVariableGet could not be located
in the dynamic link library OCI.dll"
Angela
What is your environment? Did you read the README* files that came with
DBD::Oracle and DBI? Do you have an Oracle client (at least) installed
on this machine?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Angela Chan [mailto:achan90@gmail.com]=20
Sent: Monday, February 27, 2006 12:56 PM
To: dbi-users@perl.org
Subject: Connect to Oracle
Hi,
I just install DBD::ORACLE in PERL, and try to connect to my ORACLE DB.
However, I receive the following error message. Does anyone know how to
resolve this problem? Thanks
"The procedure entry point OCINlsEnvironmentVariableGet could not be
located in the dynamic link library OCI.dll"
Angela
This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
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.
You should always include information about your platform, Perl version,
DBD::Oracle version and Oracle version, as it almost always helps with the
answer. Here are some guesses:
You mention OCI.dll, so that's Windows.
It's getting as far as loading the libraries, so you have an Oracle client
installed.
You've got DBD::Oracle installed, but it doesn't work, which implies the
test suite wasn't run on installation. So you've probably installed a binary
distribution of DBD::Oracle using PPM into ActiveState Perl?
It's complaining about OCINlsEnvironmentVariableGet which was added on
Oracle 9i, so I'm guessing you have installed a binary distribution of
DBD::Oracle that was compiled against 9i or 10g, but you have an Oracle 8i
client installed.
You could recompile DBD::Oracle against 8i if you have the Microsoft C
compiler, but since 8i is no longer supported by Oracle then you'd probably
be better off upgrading to 9i or 10g - at least on the client.
--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
> -----Original Message-----
> From: Angela Chan [mailto:achan90@gmail.com]
> Sent: 27 February 2006 19:56
> To: dbi-users@perl.org
> Subject: Connect to Oracle
>
> Hi,
>
> I just install DBD::ORACLE in PERL, and try to connect to my
> ORACLE DB.
> However, I receive the following error message. Does anyone
> know how to
> resolve this problem? Thanks
>
> "The procedure entry point OCINlsEnvironmentVariableGet could
> not be located
> in the dynamic link library OCI.dll"
>
> Angela
>
Hi, Ron,
I installed ActivePerl version 5.8.7 build 815, DBI 1.50 and DBD-Oracle 1.16
and I have Net8 (8.1.7) Oracle Client installed on my machine.
Thanks
Angela
""Reidy, Ron""
news:7209E76DACFED9469D4F5169F9880C7A9C53@mail01bldr.arraybp .com...
What is your environment? Did you read the README* files that came with
DBD::Oracle and DBI? Do you have an Oracle client (at least) installed
on this machine?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Angela Chan [mailto:achan90@gmail.com]
Sent: Monday, February 27, 2006 12:56 PM
To: dbi-users@perl.org
Subject: Connect to Oracle
Hi,
I just install DBD::ORACLE in PERL, and try to connect to my ORACLE DB.
However, I receive the following error message. Does anyone know how to
resolve this problem? Thanks
"The procedure entry point OCINlsEnvironmentVariableGet could not be
located in the dynamic link library OCI.dll"
Angela
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.
What version of Oracle is installed?
-----Original Message-----
From: Angela Chan [mailto:achan90@gmail.com]=20
Sent: Monday, February 27, 2006 2:06 PM
To: dbi-users@perl.org
Subject: Re: Connect to Oracle
Hi, Ron,
I installed ActivePerl version 5.8.7 build 815, DBI 1.50 and DBD-Oracle
1.16 and I have Net8 (8.1.7) Oracle Client installed on my machine.
Thanks
Angela
""Reidy, Ron""
news:7209E76DACFED9469D4F5169F9880C7A9C53@mail01bldr.arraybp .com...
What is your environment? Did you read the README* files that came with
DBD::Oracle and DBI? Do you have an Oracle client (at least) installed
on this machine?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Angela Chan [mailto:achan90@gmail.com]
Sent: Monday, February 27, 2006 12:56 PM
To: dbi-users@perl.org
Subject: Connect to Oracle
Hi,
I just install DBD::ORACLE in PERL, and try to connect to my ORACLE DB.
However, I receive the following error message. Does anyone know how to
resolve this problem? Thanks
"The procedure entry point OCINlsEnvironmentVariableGet could not be
located in the dynamic link library OCI.dll"
Angela
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.
This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
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.
DUH! Never mind. As someone earlier posted on this thread, you will
either need to:
1. Upgrade your Oracle client to a 9.2 or 10.1 or 10.2 version
2. Recompile your DBD::Oracle source with a MS C/C++ compiler (not
recommended unless you are truly a pretty savvy Windows C/C++ developer)
3. Downgrade your DBI/DBD::Oracle to a version which works with 8.1.
I will concur with the gentleman who earlier suggested a client upgrade.
Since 8.1 is not longer supported by Oracle, this will be easiest for
you in the long run.
rr
-----Original Message-----
From: Reidy, Ron=20
Sent: Monday, February 27, 2006 4:42 PM
To: Angela Chan; dbi-users@perl.org
Subject: RE: Connect to Oracle
What version of Oracle is installed?
-----Original Message-----
From: Angela Chan [mailto:achan90@gmail.com]=20
Sent: Monday, February 27, 2006 2:06 PM
To: dbi-users@perl.org
Subject: Re: Connect to Oracle
Hi, Ron,
I installed ActivePerl version 5.8.7 build 815, DBI 1.50 and DBD-Oracle
1.16 and I have Net8 (8.1.7) Oracle Client installed on my machine.
Thanks
Angela
""Reidy, Ron""
news:7209E76DACFED9469D4F5169F9880C7A9C53@mail01bldr.arraybp .com...
What is your environment? Did you read the README* files that came with
DBD::Oracle and DBI? Do you have an Oracle client (at least) installed
on this machine?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Angela Chan [mailto:achan90@gmail.com]
Sent: Monday, February 27, 2006 12:56 PM
To: dbi-users@perl.org
Subject: Connect to Oracle
Hi,
I just install DBD::ORACLE in PERL, and try to connect to my ORACLE DB.
However, I receive the following error message. Does anyone know how to
resolve this problem? Thanks
"The procedure entry point OCINlsEnvironmentVariableGet could not be
located in the dynamic link library OCI.dll"
Angela
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.
This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended=20
to be for the use of the individual or entity named above. If you are
not the=20
intended recipient, please be aware that any disclosure, copying,
distribution=20
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.
This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
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.
The latest version of DBD::Oracle 1.17 has a very comprehensive how-to in
the win32 readme on installing and compiling DBD::oracle with C++ etc. I
suggest to follow it will get you up and running though you have allot of
downloading to do.
Cheers
""Angela Chan""
news:20060227195546.18087.qmail@lists.develooper.com...
> Hi,
>
> I just install DBD::ORACLE in PERL, and try to connect to my ORACLE DB.
> However, I receive the following error message. Does anyone know how to
> resolve this problem? Thanks
>
> "The procedure entry point OCINlsEnvironmentVariableGet could not be
located
> in the dynamic link library OCI.dll"
>
> Angela
>
>
Thanks
Angela
""Andy Hassall""
news:20060227210055.JTDW4438.aamta12-winn.ispmail.ntl.com@ex cession...
> You should always include information about your platform, Perl version,
> DBD::Oracle version and Oracle version, as it almost always helps with the
> answer. Here are some guesses:
>
> You mention OCI.dll, so that's Windows.
>
> It's getting as far as loading the libraries, so you have an Oracle
client
> installed.
>
> You've got DBD::Oracle installed, but it doesn't work, which implies the
> test suite wasn't run on installation. So you've probably installed a
binary
> distribution of DBD::Oracle using PPM into ActiveState Perl?
>
> It's complaining about OCINlsEnvironmentVariableGet which was added on
> Oracle 9i, so I'm guessing you have installed a binary distribution of
> DBD::Oracle that was compiled against 9i or 10g, but you have an Oracle 8i
> client installed.
>
> You could recompile DBD::Oracle against 8i if you have the Microsoft C
> compiler, but since 8i is no longer supported by Oracle then you'd
probably
> be better off upgrading to 9i or 10g - at least on the client.
>
> --
> Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
> http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
>
> > -----Original Message-----
> > From: Angela Chan [mailto:achan90@gmail.com]
> > Sent: 27 February 2006 19:56
> > To: dbi-users@perl.org
> > Subject: Connect to Oracle
> >
> > Hi,
> >
> > I just install DBD::ORACLE in PERL, and try to connect to my
> > ORACLE DB.
> > However, I receive the following error message. Does anyone
> > know how to
> > resolve this problem? Thanks
> >
> > "The procedure entry point OCINlsEnvironmentVariableGet could
> > not be located
> > in the dynamic link library OCI.dll"
> >
> > Angela
> >
>
Thanks Ron.
Angela
""Reidy, Ron""
news:7209E76DACFED9469D4F5169F9880C7A9C59@mail01bldr.arraybp .com...
DUH! Never mind. As someone earlier posted on this thread, you will
either need to:
1. Upgrade your Oracle client to a 9.2 or 10.1 or 10.2 version
2. Recompile your DBD::Oracle source with a MS C/C++ compiler (not
recommended unless you are truly a pretty savvy Windows C/C++ developer)
3. Downgrade your DBI/DBD::Oracle to a version which works with 8.1.
I will concur with the gentleman who earlier suggested a client upgrade.
Since 8.1 is not longer supported by Oracle, this will be easiest for
you in the long run.
rr
-----Original Message-----
From: Reidy, Ron
Sent: Monday, February 27, 2006 4:42 PM
To: Angela Chan; dbi-users@perl.org
Subject: RE: Connect to Oracle
What version of Oracle is installed?
-----Original Message-----
From: Angela Chan [mailto:achan90@gmail.com]
Sent: Monday, February 27, 2006 2:06 PM
To: dbi-users@perl.org
Subject: Re: Connect to Oracle
Hi, Ron,
I installed ActivePerl version 5.8.7 build 815, DBI 1.50 and DBD-Oracle
1.16 and I have Net8 (8.1.7) Oracle Client installed on my machine.
Thanks
Angela
""Reidy, Ron""
news:7209E76DACFED9469D4F5169F9880C7A9C53@mail01bldr.arraybp .com...
What is your environment? Did you read the README* files that came with
DBD::Oracle and DBI? Do you have an Oracle client (at least) installed
on this machine?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Angela Chan [mailto:achan90@gmail.com]
Sent: Monday, February 27, 2006 12:56 PM
To: dbi-users@perl.org
Subject: Connect to Oracle
Hi,
I just install DBD::ORACLE in PERL, and try to connect to my ORACLE DB.
However, I receive the following error message. Does anyone know how to
resolve this problem? Thanks
"The procedure entry point OCINlsEnvironmentVariableGet could not be
located in the dynamic link library OCI.dll"
Angela
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.
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.
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.