Displaying 2 results from an estimated 2 matches for "tsnnames".
Did you mean:
tsnames
2009 Nov 16
1
Data source name not found and no default driver specified
...C 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")...
2009 Nov 16
1
Error using 32-bit R and RODBC package on 64-bit Windows Server OS with R version 2.10
...C 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"...