1

I am trying to connect to an EXASol database through odbc using R. After setting up the DSN, I can connect to the database using the RODBC package.

odbc_channel <- odbcConnect("exa", uid = "username",
                        pwd = "password")

This works fine. However, when I try to use dbConnect, the same DSN fails. 

con <- dbConnect(odbc(), 
             dsn = "exa", 
             uid = "username",
             pwd = "password")

The code begins running and never stops. Any idea what is happening? The DSN seems to be set up correctly since it works with RODBC.

Kevin Lu
  • 31
  • 2
  • 1
    Long running code does not mean it fails. Possibly the *EXASol* maintains many system/meta tables to be included in connections tab of RStudio. Try `options(connectionObserver = NULL)` at top of script to avoid. – Parfait Oct 05 '18 at 16:35
  • Perfect that was it thanks – Kevin Lu Oct 08 '18 at 07:41

0 Answers0