I am trying to troubleshoot a problem within Rstudio and not sure where to post. I am trying to access an oracle database within RStudio using RODBC. I get the following message after entering:
channel <- RODBC::odbcConnect("server",uid="user",pwd="password")
" [RODBC] ERROR: state IM003, code 160, message Specified driver could not be loaded due to system error 126: The specified module could not be found. (Oracle in OraClient11g_home1, C:\app\BuiltInAdmin\product\11.2.0\client_1\BIN\SQORA32.DLL)."
Some background. I have win 7 - 64 bit machine. I used to have 32 bit v11.x instant client installed. This got replaced with a 32 bit v12.2 client. Rstudio is running a 32 bit version or R. The C:\app\BuiltInAdmin folder doesn't exist anymore.
Does anyone know what "OraClient11g_home1" is? is this a registry value?
My global path has these entries:
"C:\app\BuiltInAdmin\product\11.2.0\client_1\bin"
"C:\instantclient_12_2"
Any ideas as to what is going on and how to go about fixing it?
Thanks in advance