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!