R connect to Oracle - library(ROracle) fail -

-

it won't load library. 

setwd("c:/users/***/desktop") install.packages('roracle_1.2-1.zip', repos = null) #installing package ‘c:/users/***/documents/r/win-library/3.3 (as ‘lib’ unspecified)  #package ‘roracle’ unpacked , md5 sums checked  library('roracle') #error in indl(x, as.logical(local), as.logical(now), ...) : unable load shared object 'c:/users/***/documents/r/win-library/3.3/roracle/libs/x64/roracle.dll': loadlibrary failure:  specified module not found.

i manually checked file path , roracle.dll there.

edit:

i have rodbc , rjdbc working. don't understand why roracle won't install:

library(roracle) error in indl(x, as.logical(local), as.logical(now), ...) :    unable load shared object 'c:/users/robsoo01/documents/r/win-library/3.3/roracle/libs/x64/roracle.dll':   loadlibrary failure:  specified module not found.  error: package or namespace load failed ‘roracle’  install.packages("roracle") installing package ‘c:/users/***/documents/r/win-library/3.3’ (as ‘lib’ unspecified) package available in source form, , may need compilation of c/c++/fortran: ‘roracle’ want attempt install these sources? y/n: y installing source package ‘roracle’  trying url 'https://cran.rstudio.com/src/contrib/roracle_1.2-2.tar.gz' content type 'application/x-gzip' length 304229 bytes (297 kb) downloaded 297 kb  * installing *source* package 'roracle' ... ** package 'roracle' unpacked , md5 sums checked error: cannot find oracle client.        please set oci_lib64 specify location. warning: running command 'sh ./configure.win' had status 1 error: configuration failed package 'roracle' * removing 'c:/users/***/documents/r/win-library/3.3/roracle' * restoring previous 'c:/users/***/documents/r/win-library/3.3/roracle' warning in install.packages :   running command '"c:/progra~1/r/r-33~1.1/bin/x64/r" cmd install -l "c:\users\***\documents\r\win-library\3.3" c:\users\***\appdata\local\temp\rtmpmvclo4/downloaded_packages/roracle_1.2-2.tar.gz' had status 1 warning in install.packages :   installation of package ‘roracle’ had non-zero exit status  downloaded source packages in     ‘c:\users\***\appdata\local\temp\rtmpmvclo4\downloaded_packages’

i'm guessing there oracle files need installing, none of documentation clear.

in order roracle install , load properly, should have oracle client 64-bit , windows 64-bit. once installed 64-bit oracle client on machine, error went away.


Comments

Post a Comment

Popular posts from this blog

matlab - error with cyclic autocorrelation function -

-
Image
i'm trying code cyclic autocorrelation function in matlab follows: t=0:(n-1); t=t*te; i_alpha=0; tau=-n2*te:te:n2*te; alpha=-1/2:1/n:1/2; ryy_cl=zeros(length(alpha),length(tau)); alpha=alpha/te ind_tau=0; i_alpha=i_alpha+1; k=tau ind_tau=ind_tau+1; if k>0 % ryy_cl(i_alpha,ind_tau)=1/length(sig_bin_syl_mod(1:end- k))*sum((sig_bin_syl_mod(1:end-k)).*sig_bin_syl_mod(k+1:end)).*exp(1i*2*pi*alpha*t(1+k:length(sig_bin_syl_mod(1:end)))); ryy_cl(i_alpha,ind_tau)=(1/n)*sum((sig_bin_syl_mod(1:end-k)).*sig_bin_syl_mod(k+1:end)).*exp(-1i*2*pi*alpha*t(1:end-k)); else ryy_cl(i_alpha,ind_tau)=(1/n)*sum((sig_bin_syl_mod(1-k:end)).*sig_bin_syl_mod(1:end+k)).*exp(-1i*2*pi*alpha*t(1-k:end)); end end end i'm getting errors, , doesn't show expecting. according below formulae, how can fix it? the code provided incomplete, difficult confidently reproduce error. in particular, haven't de...
Read more

django - (fields.E300) Field defines a relation with model 'AbstractEmailUser' which is either not installed, or is abstract -

-
i trying create customuser django project email username , add radio button truck , company. in registration process email-id registered per truck or company. mentioned radio button 'tag' , add manytomany field tag in emailuser model. when makemigrations, raising error : (fields.e300) field defines relation model 'abstractemailuser' either not installed, or abstract. i quite new django , not sure whether have created correct code wants. please me solving this. here code, models.py: import django django.contrib.auth.models import ( abstractbaseuser, baseusermanager, permissionsmixin) django.core.mail import send_mail django.db import models django.utils import timezone django.utils.translation import ugettext_lazy _ class emailusermanager(baseusermanager): """custom manager emailuser.""" def _create_user(self, email, password, is_staff, is_superuser, **extra_fields): """create , save emailus...
Read more

c# - What is a good .Net RefEdit control to use with ExcelDna? -

-
i using exceldna , c# build suite of tools. part of forms i'd want user select cells/ranges workbook. i've got application.inputbox route working...but doesn't cool... i haven't read many things excel's refedit control, , see many have in past written workarounds, in (shudder) vba or vb.net. however, none of these seem recent... best approach/control refedit functionality on form run via exceldna (if applicable)? the refedit sample project of github explores different ways of dealing threading when showing form excel add-in, main issue making refedit control .net add-in. check page links various other implementations: https://github.com/excel-dna/exceldna/wiki/links-about-refedit
Read more