Conection to Oracle DB

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

 dbconnection <- dbConnect(odbc::odbc(),
           Driver = "Oracle",
           Database = "costos", 
           UID = "npowerxxx",
           PWD = "UZWVMxxxx",
           Server = "216.xxx.xxx.xxx",
           Port = 1523
 )

Thank in advance

What's the error? That can give us a clue about your problem

Hi, this is the error:

Error in value[[3L]](cond) : nanodbc/nanodbc.cpp:950: 01000: [unixODBC]
[Driver Manager]Can't open lib '/opt/rstudio-drivers/oracle/bin/lib
/liboracleodbc_sb64.so' : file not found Calls: local ... tryCatch -&gt; 
tryCatchList -&gt; tryCatchOne -&gt; &lt;Anonymous&gt; Execution halted

Thank you

It seems that there is no driver for oracle databases installed on the shinyapps.io server, this has to be fixed on their side, if you have a paid account maybe you can get in touch with customer support, because of the holidays I think is very unlikely that they read this here.

Oracle drivers require user click through acceptance as well as an Oracle Account in order to download.
So while the Oracle professional driver is actually present in /opt/rstudio-drivers/oracle/bin/lib /liboracleodbc_sb64.so, two shared libraries are not present (libocci.so.12.1 and libclntsh.so.12.1) which prevent the driver from loading.

I will share this post with colleagues who work on the drivers who might be able to add more context.

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