Connection from Oracle to R doesn't work

Hello, , I have some problems connecting the R Studio with Oracle by OBDC. The laptop uses an OS Windows 10 Pro. I have tried many times with libraries: RODBC and DBI but the point is the concetions Works until you run the last sentence dataframe.

channel <- odbcConnect("TTT", uid="DWHGYS_VIS", pwd="DVIS123") -[quote="carlos_rc24, post:1, topic:20309, full:true"]

Hi, can anyone tell me how to make the connection from shinyapps.io to a oracle database, I have used this string connection but I get a error

channel <- odbcConnect("TTT", uid="DWHGYS_VIS", pwd="DVIS123") --works
dataframe <- sqlQuery(channel, "
 SELECT *
 FROM
 TTT.TABLA_1")

it doesn't work

please your hekp while searching in other comments!

Do you have the necessary Oracle drivers installed? See the requirements here:
https://db.rstudio.com/databases/oracle/

I am suspicious that the connection from shinyapps.io to Oracle will not work, since the Oracle client is almost certainly not installed. The RStudio Professional Drivers are installed on shinyapps.io, but the Oracle client is not, so a connection to an Oracle database will probably not work.

That said, connections to other databases from shinyapps.io are possible.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.