Re: undefined references when installing DBD::Oracle on Windows Server 2008

On 10/29/2010 3:25 PM, Alexander Saip wrote:
Ok that sounds like it I will have to fix that if it is in the present 
release?
Thanks for pointing that out.
Cheers
John Scoles

> I guess not... I eventually managed to build, test and install 
> DBD::Oracle. The culprit turned out to be oci.def file in the CPAN 
> folder. After I edited it by adding all those "undefined 
> references", everything worked like a charm. Quick note: I switched to 
> the 32-bit versions of Perl and Oracle IC, but I'm almost positive now 
> that it would work in the 64-bit world as well.
>
> Date: Fri, 29 Oct 2010 14:15:35 -0400
> From: [email protected]
> To: [email protected]
> CC: [email protected]
> Subject: Re: undefined references when installing DBD::Oracle on 
> Windows Server 2008
>
> 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: [email protected] <mailto:[email protected]>
>     To: [email protected] <mailto:[email protected]>
>     CC: [email protected] <mailto:[email protected]>
>     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: [email protected] <mailto:[email protected]>
>         > To: [email protected] <mailto:[email protected]>
>         > CC: [email protected] <mailto:[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
>         >
>
>
>