On 10/29/2010 1:13 PM, Alexander Saip wrote:
Might be a strawberry perl thing??
Can you give it a try with Activestate perl or with and eariler
DBD::Oracle 1.24 or 1.23 or the 10 instant client??
Cheers
John Scoles
Sorry for the delayed response. I had to make Oracle connection work
ASAP yesterday, so I simply installed DBD::ODBC and used the Oracle
ODBC driver. Today, I checked the IC SDK 'include' folder and found
all those function headers (and many more) in ociap.h. The compiler
does include that folder in its list. What else may cause those errors?
Date: Thu, 28 Oct 2010 13:03:52 -0400
From: sco...@pythian.com
To: as...@msn.com
CC: dbi-users@perl.org
Subject: Re: undefined references when installing DBD::Oracle on
Windows Server 2008
On 10/28/2010 12:18 PM, Alexander Saip wrote:
John,
thanks for your comments. I have successfully installed
DBD::Oracle on a Windows 7 (64-bit) box, but used both 32-bit
Strawberry Perl and Oracle instant client. That may be the way for
me to go, unless I can make the 64-bit stuff work together.
I do have the Oracle instant clent SDK folder in the
E:/app/Dna_Admin/product/11.2.0/client_1/instantclient_11_2
directory with all the goodies, which apparently doesn't help
much. Yes, the flags you mention (ORA_OCI_102 and ORA_OCI_112) are
set in the Makefile. Where should I look for those command files
that you refer to?
Thanks again,
They would or should be part of the .dll
You might be able to look at the dll and see if the commands are
there? I can't remember how to do that off hand long time ago since my
VB days.
The are usually in the .h files as well. Try just a text search of
any .h files in that client.
You might want to try the 10 IC and see if it works with that one.
Cheers
John Scoles
Alexander Saip
> Date: Thu, 28 Oct 2010 11:51:54 -0400
> From: sco...@pythian.com <mailto:sco...@pythian.com>
> To: as...@msn.com <mailto:as...@msn.com>
> CC: dbi-users@perl.org <mailto:dbi-users@perl.org>
> Subject: Re: undefined references when installing DBD::Oracle on
Windows Server 2008
>
> On 10/28/2010 10:23 AM, Alexander Saip wrote:
> > Hi Everybody,
> >
> > Windows Server 2008 R2 Enterprise (64-bit) running Strawberry
Perl, as follows:
>
> Strawberry Perl
>
>
> never did DBD::Oracle to like it.
> myself had you installed it before on a box with Strawberry??
>
> Oracle.o:Oracle.c:(.text+0x34a2): undefined reference to `OCIPing'
>
> > dbdimp.o:dbdimp.c:(.text+0xb29d): undefined reference to
`OCISessionRelease'
> > dbdimp.o:dbdimp.c:(.text+0xb6ea): undefined reference to
`OCISessionPoolDestroy'
> > dbdimp.o:dbdimp.c:(.text+0xe15a): undefined reference to
`OCISessionPoolCreate'
> > dbdimp.o:dbdimp.c:(.text+0xebf8): undefined reference to
`OCISessionGet'
> > dbdimp.o:dbdimp.c:(.text+0xedd2): undefined reference to
`OCISessionPoolDestroy'
> > collect2: ld returned 1 exit status
> > dmake: Error code 129, while making
'blib\arch\auto\DBD\Oracle\Oracle.dll'
> >
> The above means that the ORA_OCI_102 and the ORA_OCI_112 precompile
> flags are being set but your
>
> Oracle.dll
>
> does not have the the access to these commands files for what
ever reason
>
> Me I would get the rest of the instantclient (the SDK) from
Oracle and
> give it another try
>
> cheers
> John Scoles
> > ----------------------------
> >> perl Makefile.PL -s OCIPing
> > ----------------------------
> > Using DBI 1.615 (for perl 5.012001 on
MSWin32-x64-multi-thread) installed in
c:/strawberry/perl/vendor/lib/auto/DBI/
> > Installing on a MSWin32, Ver#6.1
> > Using Oracle in
E:/app/Dna_Admin/product/11.2.0/client_1/instantclient_11_2
> > DEFINE _SQLPLUS_RELEASE = "1102000100" (CHAR)
> > Oracle version 11.2.0.1 (11.2)
> > Searching for symbol 'OCIPing' in
E:/app/Dna_Admin/product/11.2.0/client_1/instantclient_11_2 ...
> > The system cannot find the path specified.
> > Search done.
> > (Please only include the 'interesting' parts when mailing.)
> >
> > I wonder where these missing pieces are supposed to be, or
what may be wrong with my environment setup?
> >
> > Thank you in advance,
> >
> > Alexander Saip
>
