RStudio Connect and RODBC

Posit Professional & Hosted Products
1

Hello, I'm trying to run applications on RStudio Connect that connect to an Oracle database using RODBC. These connections work fine on the RStudio IDE on my pc and even on the linux server when we launch R and set up the connection. However, applications deployed to RStudio Connect on the same linux server produce this error: [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data source name not found, and no default driver specified

Any ideas? Thanks!

2

Hi @jvail, did you install the database drivers provided by RStudio? http://db.rstudio.com/rstudio/pro-drivers/

3

how did you configured the RStudio Connect Server with the DSN ? Where did you put the odbc.ini and odbcinst.ini files ?

4

Thanks! I needed to copy both of those files to the root directory from the usr directory. It's working now.

1 Like