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