I forgot to mention that it's running Windows Server 2003 x64 OS version
On Mon, Nov 16, 2009 at 11:22 AM, helpme <myrquesti...@gmail.com> 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.
