[R] Data source name not found and no default driver specified
I'm stumped. When trying to connect to Oracle using the RODBC package I get
an error:
*[RODBC] Data source name not found and no default driver specified.
ODBC connect failed.*
I've read over all the posts and documentation manuals.
The system is Windows Server 2003 with R 2.81. and the latest downloadable
RODBC package. The Oracle SID/DSN is mfopdw. I made sure to add it to
Control Panel->Administrative Priviledges->Microsoft ODBC system/user DNS.
I've also tried the following in no particular order:
1.) Turn on all oracle services in control panel->administrative
priviledges.
2.) Checked tsnnames.ora for SID.
3.) Add microsoft ODBC service to Control Panel services for SID
4.) Use Sqldeveler to test connection another way besides R (It was
successful)
5.) channel<-odbcDriverConnect(connection="Driver={Microsoft ODBC for
Oracle}; DSN=abc,UID=abc;PWD=abc;"case="oracle")
received error drivers SQLAllocHandle on SQL_HANDLE_ENV failed one time;
another time I got the error that Oracle client and networking components
7.3 or greater is not found.
6.) tnsping mfopdw
lsnrctl start mfopdw
tried to add oracle/bin to path
Nothing is working.
Please advise.
Thank you,
[[alternative HTML version deleted]]
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Re: [R] Data source name not found and no default driver specified
I forgot to mention that it's running Windows Server 2003 x64 OS version
On Mon, Nov 16, 2009 at 11:22 AM, helpme wrote:
> I'm stumped. When trying to connect to Oracle using the RODBC package I get
> an error:
> *[RODBC] Data source name not found and no default driver specified.
> ODBC connect failed.*
>
> I've read over all the posts and documentation manuals.
> The system is Windows Server 2003 with R 2.81. and the latest downloadable
> RODBC package. The Oracle SID/DSN is mfopdw. I made sure to add it to
> Control Panel->Administrative Priviledges->Microsoft ODBC system/user DNS.
>
> I've also tried the following in no particular order:
>
> 1.) Turn on all oracle services in control panel->administrative
> priviledges.
> 2.) Checked tsnnames.ora for SID.
> 3.) Add microsoft ODBC service to Control Panel services for SID
> 4.) Use Sqldeveler to test connection another way besides R (It was
> successful)
> 5.) channel<-odbcDriverConnect(connection="Driver={Microsoft ODBC for
> Oracle}; DSN=abc,UID=abc;PWD=abc;"case="oracle")
>
> received error drivers SQLAllocHandle on SQL_HANDLE_ENV failed one time;
> another time I got the error that Oracle client and networking components
> 7.3 or greater is not found.
>
> 6.) tnsping mfopdw
>
> lsnrctl start mfopdw
>
> tried to add oracle/bin to path
>
> Nothing is working.
>
>
> Please advise.
>
> Thank you,
>
[[alternative HTML version deleted]]
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
[R] Error using 32-bit R and RODBC package on 64-bit Windows Server OS with R version 2.10
I am receiving an error when trying to connect to the Oracle Database using
RODBC on a 64-bit Windows Server OS. The version of R is 2.10.0-win32.exe
Is this the wrong version. Does RODBC only work with 32-bit ODBC drivers?
've read over all the posts and documentation manuals.
The system is Windows Server 2003 with R 2.81. and the latest downloadable
RODBC package. The Oracle SID/DSN is mfopdw. I made sure to add it to
Control Panel->Administrative Priviledges->Microsoft ODBC system/user DNS.
I've also tried the following in no particular order:
1.) Turn on all oracle services in control panel->administrative
priviledges.
2.) Checked tsnnames.ora for SID.
3.) Add microsoft ODBC service to Control Panel services for SID
4.) Use Sqldeveler to test connection another way besides R (It was
successful)
5.) channel<-odbcDriverConnect(
connection="Driver={Microsoft ODBC for Oracle};
DSN=abc,UID=abc;PWD=abc;"case="oracle")
received error drivers SQLAllocHandle on SQL_HANDLE_ENV failed one time;
another time I got the error that Oracle client and networking components
7.3 or greater is not found.
6.) tnsping mfopdw
lsnrctl start mfopdw
tried to add oracle/bin to path
Nothing is working.
-Melanie
[[alternative HTML version deleted]]
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Re: [R] Error using 32-bit R and RODBC package on 64-bit Windows Server OS with R version 2.10
Now that I know RODBC only works with 32-bit ODBC drivers this explains the
problem I was having.
The system has a 64 bit ODBC driver is definitely installed. I can tell
because when you go to system32 folder and click on odbcad32.exe it goes to
the Microsoft ODBC manager where I can select the driver installed for the
64-bit Oracle system.
The system32 folder contains the 64 bit driver for ODBC. When I go to the
syswow64 directory and click on the odbcad32.exe it does not take me to the
Microsoft ODBC manager. Instead I get this error:
Navigate to C:\Windows\syswow64\odbcad32.exe
2.) Select System DSN
3.) Add "Microsoft ODBC for Oracle"
I receive this error: The Oracle(tm) client and networking components were
not found. These components are supplied by Oracle Corporation and are part
of the Oracle Version 7.3 (or greater) client software installation. You
will be unable to use this driver until these components have been
installed.
I don't believe the 32-bit ODBC driver is present. What is the best way to
tell if the 32-bit Oracle client software isn't installed and I'm wondering
if anyone has experience to install it on a 64-bit system and call it from
RODC?
On Mon, Nov 16, 2009 at 4:54 PM, Marc Schwartz wrote:
> On Nov 16, 2009, at 2:39 PM, helpme wrote:
>
> I am receiving an error when trying to connect to the Oracle Database
>> using
>> RODBC on a 64-bit Windows Server OS. The version of R is 2.10.0-win32.exe
>>
>> Is this the wrong version. Does RODBC only work with 32-bit ODBC drivers?
>>
>> 've read over all the posts and documentation manuals.
>> The system is Windows Server 2003 with R 2.81. and the latest downloadable
>> RODBC package. The Oracle SID/DSN is mfopdw. I made sure to add it to
>> Control Panel->Administrative Priviledges->Microsoft ODBC system/user DNS.
>>
>> I've also tried the following in no particular order:
>>
>> 1.) Turn on all oracle services in control panel->administrative
>> priviledges.
>> 2.) Checked tsnnames.ora for SID.
>> 3.) Add microsoft ODBC service to Control Panel services for SID
>> 4.) Use Sqldeveler to test connection another way besides R (It was
>> successful)
>> 5.) channel<-odbcDriverConnect(
>> connection="Driver={Microsoft ODBC for Oracle};
>> DSN=abc,UID=abc;PWD=abc;"case="oracle")
>>
>> received error drivers SQLAllocHandle on SQL_HANDLE_ENV failed one time;
>> another time I got the error that Oracle client and networking components
>> 7.3 or greater is not found.
>>
>> 6.) tnsping mfopdw
>>
>> lsnrctl start mfopdw
>>
>> tried to add oracle/bin to path
>>
>> Nothing is working.
>>
>
> Three quick comments:
>
> 1. A better place to post these types of queries would be on the R-SIG-DB
> e-mail list, which is focused in this domain. More info here:
>
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>
> 2. Prof. Ripley will be a more definitive resource, so I would wait until
> he might respond.
>
> 3. If you have not yet, be sure to read the RODBC vignette, which is
> available either via:
>
> vignette("ROBDC")
>
> or online at:
>
> http://cran.r-project.org/web/packages/RODBC/vignettes/RODBC.pdf
>
>
> That all being said, since you have now posted what may be the root cause
> of your problem, which is the 64/32 bit details, I will venture a guess to
> say that this may be the problem. Since there is not a 64 bit version of R
> for Windows (save I believe the Revolution commercial release), if you are
> using 64 bit Oracle client binaries and ODBC drivers (if they exist), they
> will not be compatible with 32 bit R/RODBC.
>
> I know that on OSX, with 64 bit R/RODBC and 32 bit ODBC drivers for Oracle,
> the connectivity would not work, so it seems reasonable that the reverse
> configuration would not be compatible either.
>
> So, first, I would be sure that you are using 32 bit ODBC drivers for
> Oracle on Windows and not 64 bit. If you installed any other Oracle client
> related software, that likely also needs to be 32 bit as well.
>
> Then I would review the above vignette document and be sure that any
> general installation references and those specifically pertaining to Windows
> have been followed consistently, especially configuring $PATH and other
> environmental configuration items required for Oracle itself, which on some
> platforms usually include things like $ORACLE_HOME, $TNS_ADMIN and so forth.
> You indicate above:
>
>
> "tried to add oracle/bin to path"
>
> which does not definitively indicate that you actually did so. Did you?
> Also, check the capitalization, as the path is normall
[R] Missing/Incomplete Data Study
Hi, I have a project where unsupervised learning failed to produce rules using Weka. I wanted to know if there are any tools in R that can be used to assess how well timestamps of event, task, load, and hardware logs for completeness or missing and incomplete data to be able to know whether it impacted our unsupervised approach. Please advise. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Error using 32-bit R and RODBC package on 64-bit Windows Server OS with R version 2.10
Thank you for the link to the 32 bit Windows Oracle downloads for the Instant Client. That solved the problem. I'm now able to connect to Oracle database from R using the RODBC library. Thank you Mark! -Melanie On Wed, Nov 18, 2009 at 6:23 PM, Marc Schwartz wrote: > Just to clarify on your first point, it is not that RODBC cannot work with > 64 bit ODBC drivers. Given your particular configuration of 64 bit Windows, > 32 bit R and 64 bit ODBC drivers, you are likely running into compatibility > issues. > > From the error message below, it would seem that you are also either > missing the requisite Oracle client software, or your system configuration > variables are not set or are not set to the proper paths. > > The 32 bit Windows Oracle downloads are available from: > > > http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html > > Now, I don't run Windows (have not in a long time), so I am not clear as to > the subtleties that may be in play here given that you may be installing 32 > bit drivers over an existing 64 bit installation. You may need to remove the > 64 bit install, in order to have a clean install of the 32 bit Oracle client > apps. If they install into different locations, that might help to solve the > problem, in which case, you need to be careful in configuring any system > environment variables so that they point to the proper location. > > If you have access to in-house tech support or an Oracle SysAdmin, I would > highly recommend that you seek them out to aid in ensuring that you end up > with a clean 32 bit Oracle client installation. As I noted previously, I > would be sure that you can connect to the Oracle server using the 32 bit > Oracle Instant Client application as a test to ensure that OS and Oracle > related configuration issues have been resolved. Then test the RODBC > connection within R. That two step process has helped me to debug local > configuration issues on both Linux and OSX. > > HTH, > > Marc Schwartz > > > On Nov 18, 2009, at 3:12 PM, helpme wrote: > > Now that I know RODBC only works with 32-bit ODBC drivers this explains >> the >> problem I was having. >> >> The system has a 64 bit ODBC driver is definitely installed. I can tell >> because when you go to system32 folder and click on odbcad32.exe it goes >> to >> the Microsoft ODBC manager where I can select the driver installed for the >> 64-bit Oracle system. >> >> The system32 folder contains the 64 bit driver for ODBC. When I go to the >> syswow64 directory and click on the odbcad32.exe it does not take me to >> the >> Microsoft ODBC manager. Instead I get this error: >> >> Navigate to C:\Windows\syswow64\odbcad32.exe >> 2.) Select System DSN >> 3.) Add "Microsoft ODBC for Oracle" >> I receive this error: The Oracle(tm) client and networking components were >> not found. These components are supplied by Oracle Corporation and are >> part >> of the Oracle Version 7.3 (or greater) client software installation. You >> will be unable to use this driver until these components have been >> installed. >> >> >> >> I don't believe the 32-bit ODBC driver is present. What is the best way to >> tell if the 32-bit Oracle client software isn't installed and I'm >> wondering >> if anyone has experience to install it on a 64-bit system and call it from >> RODC? >> >> >> On Mon, Nov 16, 2009 at 4:54 PM, Marc Schwartz >> wrote: >> >> On Nov 16, 2009, at 2:39 PM, helpme wrote: >>> >>> I am receiving an error when trying to connect to the Oracle Database >>> >>>> using >>>> RODBC on a 64-bit Windows Server OS. The version of R is >>>> 2.10.0-win32.exe >>>> >>>> Is this the wrong version. Does RODBC only work with 32-bit ODBC >>>> drivers? >>>> >>>> 've read over all the posts and documentation manuals. >>>> The system is Windows Server 2003 with R 2.81. and the latest >>>> downloadable >>>> RODBC package. The Oracle SID/DSN is mfopdw. I made sure to add it to >>>> Control Panel->Administrative Priviledges->Microsoft ODBC system/user >>>> DNS. >>>> >>>> I've also tried the following in no particular order: >>>> >>>> 1.) Turn on all oracle services in control panel->administrative >>>> priviledges. >>>> 2.) Checked tsnnames.ora for SID. >>>> 3.) Add microsoft ODBC service to Control Panel services for SID >>>> 4.) Use Sqldeveler to te
