So, I tried to go back and work out the process with the odbc package.
I am operating on a Windows computer. When I used RODBC, I used a ‘User DSN’ that was connected to the perfect Driver through the TNS Service Name. I knew it was good because it had a drop down menu to connect and the ‘Test Connection’ push button told me so :). None of that has changed.
con <- RODBC::odbcConnect(“RcsdBASE Files”,
Unfortunately, when using similar call to odbc, it did not work.
con <- DBI::dbConnect(odbc::odbc(),
Driver = “Oracle in OraHome112_64_home_1”,
Host = “RcsdBASE Files”,
SVC = “CSDPRO”,
UID = “xxxxx”,
PWD = “xxxxx”,
Port = 1521)
I got this error: ORA-12560: TNS:protocol adapter error.
I tried this a few different ways…
- I used the argument names from ?DBI:dbConnect instead of those specified in the database book.
- I stripped out the arguments which used defaults to see if I would get lucky.
- Instead of the fields from the Windows ‘ODBC Data Source Administrator’, I used those from the Oracle ‘About’ information dropdown.
Needless to say, I just started throwing a bunch of stuff at the wall to see what would stick. I think I need some background knowledge. Any good reads on ODBC connections not sponsored by Microsoft or Oracle?