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