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: [email protected]
> > To: [email protected]
> > CC: [email protected]
> > 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
> >