Apologies if this is the wrong topic...
We're trying to setup a connection (via RODBC) to a Denodo v8 database via ODBC. The connection works perfectly when we run our test code through the R session terminal window, e.g. R < testscript.R --no-save but does not work when the same code is run within the R session console.
In particular, we get past the authentication step (i.e. if we enter invalid creds we get the expected error) but as soon as it's authenticated, the connection is terminated with the following error:
Error: nanodbc/nanodbc.cpp:1118: 00000: [unixODBC]Could not send Query(connection dead)
Is this something anyone else has experienced?