RODBC From R studio issue

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?

Just wondering if anyone has any ideas on this?

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

If you have a query related to it or one of the replies, start a new topic and refer back with a link.