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: 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/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
> 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 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
>
