R devel - May 2008 - Error in building ROracle in Windows with R 2.6.2 and Oracle 10g.

Hi,

I need to use ROracle to communicate with Oracle from R program in windows
environment. I am using Oracle 10g, R 2.6.2.  I found a pre-compiled binary
for ROracle for Oracle version 9.2. When I am trying to use it with Oracle
10g I get the following error:

con <- dbConnect(drv, "user/passwd at dbname");

Error in function (classes, fdef, mtable)  :
  unable to find an inherited method for function "dbConnect", for
signature "OraDriver"

I then decided to compile ROracle myself.  I downloaded ROracle src from
below:

      http://cran.r-project.org/web/packages/ROracle/index.html

When I was following the build instructions to run the makefile
Makefile.win I got the following error:

NMAKE : fatal error U1073: don't know how to make
'c:\\PROGRA~1\\R\\R-2.6.2\\src\\gnuwin32\\Rdll.lib'

I did not see Rdll.lib anywhere. Do I need to have the src for R as well ?
Can anyone provide me a detailed instruction for building ROracle or is
there a place where I can get a pre compiled binary for Oracle 10g ?

I had sent an email to the maintainer of the package but have not got any
response.

Thanks,
Ajay.




-----------------------------------------------------------------------------
AVIS : Ce courrier et ses pieces jointes sont destines a leur seul destinataire
et peuvent contenir des informations confidentielles appartenant a bioMerieux.
Si vous n'etes pas destinataire, vous etes informe que toute lecture,
divulgation, ou reproduction de ce message et des pieces jointes est strictement
interdite. Si vous avez recu ce message par erreur merci d'en prevenir
l'expediteur et de le detruire, ainsi que ses pieces jointes.

NOTICE: This message and attachments are intended only for the use of their
addressee and may contain confidential information belonging to bioMerieux. If
you are not the intended recipient, you are hereby notified that any reading,
dissemination, distribution, or copying of this message, or any attachment, is
strictly prohibited. If you have received this message in error, please notify
the original sender immediately and delete this message, along with any
attachments.

Ajay DAS wrote:
> Hi,
> 
> I need to use ROracle to communicate with Oracle from R program in windows
> environment. I am using Oracle 10g, R 2.6.2.  I found a pre-compiled binary
> for ROracle for Oracle version 9.2. When I am trying to use it with Oracle
> 10g I get the following error:
> 
> con <- dbConnect(drv, "user/passwd at dbname");
> 
> Error in function (classes, fdef, mtable)  :
>   unable to find an inherited method for function "dbConnect",
for
> signature "OraDriver"
> 
> I then decided to compile ROracle myself.  I downloaded ROracle src from
> below:
> 
>       http://cran.r-project.org/web/packages/ROracle/index.html
> 
> When I was following the build instructions to run the makefile
> Makefile.win I got the following error:
> 
> NMAKE : fatal error U1073: don't know how to make
> 'c:\\PROGRA~1\\R\\R-2.6.2\\src\\gnuwin32\\Rdll.lib'

Since the error message tells about "NAMKE", it seems you are not
using
the recommended compiler and tool collection as suggested in the manual 
R Installation and Administration...

Uwe Ligges



> I did not see Rdll.lib anywhere. Do I need to have the src for R as well ?
> Can anyone provide me a detailed instruction for building ROracle or is
> there a place where I can get a pre compiled binary for Oracle 10g ?
> 
> I had sent an email to the maintainer of the package but have not got any
> response.
> 
> Thanks,
> Ajay.
> 
> 
> 
> 
>
-----------------------------------------------------------------------------
> AVIS : Ce courrier et ses pieces jointes sont destines a leur seul
destinataire et peuvent contenir des informations confidentielles appartenant a
bioMerieux. Si vous n'etes pas destinataire, vous etes informe que toute
lecture, divulgation, ou reproduction de ce message et des pieces jointes est
strictement interdite. Si vous avez recu ce message par erreur merci d'en
prevenir l'expediteur et de le detruire, ainsi que ses pieces jointes.
> 
> NOTICE: This message and attachments are intended only for the use of their
addressee and may contain confidential information belonging to bioMerieux. If
you are not the intended recipient, you are hereby notified that any reading,
dissemination, distribution, or copying of this message, or any attachment, is
strictly prohibited. If you have received this message in error, please notify
the original sender immediately and delete this message, along with any
attachments.
> 
> ______________________________________________
> R-devel at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel

Hi Uwe,

Thanks for your response !

This is what the document (INSTALL file in ROracle src package that I
downloaded) says:

Windows:

  To compile under windows see the Makefile.win in the 'src' directory
  of the ROracle package.  You'll need the Developer's Package from the
  Oracle's client software and Microsoft Visual C++.

  To install the Windows binary, you'll need the Oracle runtime libraries
  (and make sure $ORACLE_HOME/bin is in your PATH).

  NOTE: You may override the Oracle libraries and/or library directories
  using the PKG_CPPFLAGS and/or PKG_LIBS variables (for details see
  "Writing R Extensions").

Microsoft Visual C++ does not have make. It has NMAKE which I believe works
like make. So which tool should I use to run the makefile in Windows ?

Is anyone using ROracle for windows for Oracle 10g ?

Thanks,
Ajay.



                      Uwe Ligges
                      <ligges at statistik.tu-d        To:       Ajay DAS
<Ajay.DAS at na.biomerieux.com>
                      ortmund.de>                   cc:       r-devel at
r-project.org
                                                    Subject:  Re: [Rd] Error in
building ROracle in Windows with R 2.6.2 and Oracle 10g.
                      05/01/2008 10:37 AM








Ajay DAS wrote:
> Hi,
>
> I need to use ROracle to communicate with Oracle from R program in
windows
> environment. I am using Oracle 10g, R 2.6.2.  I found a pre-compiled
binary
> for ROracle for Oracle version 9.2. When I am trying to use it with
Oracle
> 10g I get the following error:
>
> con <- dbConnect(drv, "user/passwd at dbname");
>
> Error in function (classes, fdef, mtable)  :
>   unable to find an inherited method for function "dbConnect",
for
> signature "OraDriver"
>
> I then decided to compile ROracle myself.  I downloaded ROracle src from
> below:
>
>       http://cran.r-project.org/web/packages/ROracle/index.html
>
> When I was following the build instructions to run the makefile
> Makefile.win I got the following error:
>
> NMAKE : fatal error U1073: don't know how to make
> 'c:\\PROGRA~1\\R\\R-2.6.2\\src\\gnuwin32\\Rdll.lib'

Since the error message tells about "NAMKE", it seems you are not
using
the recommended compiler and tool collection as suggested in the manual
R Installation and Administration...

Uwe Ligges



> I did not see Rdll.lib anywhere. Do I need to have the src for R as well
?
> Can anyone provide me a detailed instruction for building ROracle or is
> there a place where I can get a pre compiled binary for Oracle 10g ?
>
> I had sent an email to the maintainer of the package but have not got any
> response.
>
> Thanks,
> Ajay.
>
>
>
>
>
-----------------------------------------------------------------------------
> AVIS : Ce courrier et ses pieces jointes sont destines a leur seul
destinataire et peuvent contenir des informations confidentielles
appartenant a bioMerieux. Si vous n'etes pas destinataire, vous etes
informe que toute lecture, divulgation, ou reproduction de ce message et
des pieces jointes est strictement interdite. Si vous avez recu ce message
par erreur merci d'en prevenir l'expediteur et de le detruire, ainsi que
ses pieces jointes.
>
> NOTICE: This message and attachments are intended only for the use of
their addressee and may contain confidential information belonging to
bioMerieux. If you are not the intended recipient, you are hereby notified
that any reading, dissemination, distribution, or copying of this message,
or any attachment, is strictly prohibited. If you have received this
message in error, please notify the original sender immediately and delete
this message, along with any attachments.
>
> ______________________________________________
> R-devel at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel

I looked at the README file also. I used mingw utility to create Rdll.lib.
Then it complained about :

      LINK : fatal error LNK1181: cannot open input file "fp10.obj"

I do not know where will I get the file fp10.obj ? Any suggestion ?

Thanks,
Ajay.



                      Uwe Ligges
                      <ligges at statistik.tu-d        To:       Ajay DAS
<Ajay.DAS at na.biomerieux.com>
                      ortmund.de>                   cc:       r-devel at
r-project.org
                                                    Subject:  Re: [Rd] Error in
building ROracle in Windows with R 2.6.2 and Oracle 10g.
                      05/01/2008 11:38 AM








Ajay DAS wrote:
> Hi Uwe,
>
> Thanks for your response !
>
> This is what the document (INSTALL file in ROracle src package that I
> downloaded) says:
>
> Windows:
>
>   To compile under windows see the Makefile.win in the 'src'
directory
>   of the ROracle package.  You'll need the Developer's Package from
the
>   Oracle's client software and Microsoft Visual C++.
>
>   To install the Windows binary, you'll need the Oracle runtime
libraries
>   (and make sure $ORACLE_HOME/bin is in your PATH).
>
>   NOTE: You may override the Oracle libraries and/or library directories
>   using the PKG_CPPFLAGS and/or PKG_LIBS variables (for details see
>   "Writing R Extensions").
>
> Microsoft Visual C++ does not have make. It has NMAKE which I believe
works
> like make. So which tool should I use to run the makefile in Windows ?
Sorry about that, forgot that you need MS VC++ for that reason.

See the file "README.packages" in .../src/gnuwin32 and its section on
using VC++.

Best wishes,
uwe Ligges

> Is anyone using ROracle for windows for Oracle 10g ?
>
> Thanks,
> Ajay.
>
>
>
>                       Uwe Ligges
>                       <ligges at statistik.tu-d        To:       Ajay
DAS
<Ajay.DAS at na.biomerieux.com>
>                       ortmund.de>                   cc:
r-devel at r-project.org
>                                                     Subject:  Re: [Rd]
Error in building ROracle in Windows with R 2.6.2 and Oracle
10g.
>                       05/01/2008 10:37 AM
>
>
>
>
>
>
>
>
> Ajay DAS wrote:
>> Hi,
>>
>> I need to use ROracle to communicate with Oracle from R program in
> windows
>> environment. I am using Oracle 10g, R 2.6.2.  I found a pre-compiled
> binary
>> for ROracle for Oracle version 9.2. When I am trying to use it with
> Oracle
>> 10g I get the following error:
>>
>> con <- dbConnect(drv, "user/passwd at dbname");
>>
>> Error in function (classes, fdef, mtable)  :
>>   unable to find an inherited method for function
"dbConnect", for
>> signature "OraDriver"
>>
>> I then decided to compile ROracle myself.  I downloaded ROracle src
from
>> below:
>>
>>       http://cran.r-project.org/web/packages/ROracle/index.html
>>
>> When I was following the build instructions to run the makefile
>> Makefile.win I got the following error:
>>
>> NMAKE : fatal error U1073: don't know how to make
>> 'c:\\PROGRA~1\\R\\R-2.6.2\\src\\gnuwin32\\Rdll.lib'
>
>
> Since the error message tells about "NAMKE", it seems you are not
using
> the recommended compiler and tool collection as suggested in the manual
> R Installation and Administration...
>
> Uwe Ligges
>
>
>
>
>> I did not see Rdll.lib anywhere. Do I need to have the src for R as
well
> ?
>> Can anyone provide me a detailed instruction for building ROracle or is
>> there a place where I can get a pre compiled binary for Oracle 10g ?
>>
>> I had sent an email to the maintainer of the package but have not got
any
>> response.
>>
>> Thanks,
>> Ajay.
>>
>>
>>
>>
>>
>
-----------------------------------------------------------------------------
>
>> AVIS : Ce courrier et ses pieces jointes sont destines a leur seul
> destinataire et peuvent contenir des informations confidentielles
> appartenant a bioMerieux. Si vous n'etes pas destinataire, vous etes
> informe que toute lecture, divulgation, ou reproduction de ce message et
> des pieces jointes est strictement interdite. Si vous avez recu ce
message
> par erreur merci d'en prevenir l'expediteur et de le detruire,
ainsi que
> ses pieces jointes.
>> NOTICE: This message and attachments are intended only for the use of
> their addressee and may contain confidential information belonging to
> bioMerieux. If you are not the intended recipient, you are hereby
notified
> that any reading, dissemination, distribution, or copying of this
message,
> or any attachment, is strictly prohibited. If you have received this
> message in error, please notify the original sender immediately and
delete
> this message, along with any attachments.
>> ______________________________________________
>> R-devel at r-project.org mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-devel
>
>
>
>
>