Re: Connect to Oracle

Thanks

Angela
""Andy Hassall"" <andy@xxxxxxxxxxx> wrote in message
news:20060227210055.JTDW4438.aamta12-winn.ispmail.ntl.com@xxxxxxxxxxxx
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@xxxxxxxxxxx :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

-----Original Message-----
From: Angela Chan [mailto:achan90@xxxxxxxxx]
Sent: 27 February 2006 19:56
To: dbi-users@xxxxxxxx
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




.

Relevant Pages

  • Compiling and running DBD for Oracle 10g without installing Oracle
    ... I recently had to compile the DBD modules for Oracle 10g on machines, ... perl, DBI etc. of recent enough version ... Oracle 10g installation disk for your architecture (available at ...
    (perl.dbi.users)
  • Compiling and running DBD for Oracle 10g without installing Oracle
    ... I recently had to compile the DBD modules for Oracle 10g on machines, ... perl, DBI etc. of recent enough version ... Oracle 10g installation disk for your architecture (available at ...
    (perl.dbi.users)
  • Asp.net/vb and Oracle
    ... setup on other machines where I have installed the Oracle 9i client, ... Oracle 9.0 odbc drivers will connect to my oracle database when debugging. ... Oracle client and networking components were not found. ... later client software installation. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Asp.net/vb and Oracle
    ... Oracle Provider for OLE DB components, as well as the orcle Data Provider for ... setup on other machines where I have installed the Oracle 9i client, ... Oracle client and networking components were not found. ... later client software installation. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: 9i linux install: permission problems: what is "oracle user"
    ... The existing documentation says to create a separate linux user "bob" ... "oracle" account to run the Oracle install program. ... The installation should have been done as 'oracle'. ...
    (comp.databases.oracle.server)