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.