odbc icon indicating copy to clipboard operation
odbc copied to clipboard

Problem connecting to denodo

Open Mani14 opened this issue 2 years ago • 1 comments

library(odbc)
con <- dbConnect(odbc::odbc(),
                 Driver = "Denodo",
                 Server = "denodous-db.com",
                 Database = "dev-db",
                 UID = "mk12345",
                 PWD = "Welcome")

table_list <- dbListTables(con)
print(table_list)

Error: nanodbc/nanodbc.cpp:1135: 00000: [unixODBC]Could not send Query(connection dead)

This is the error message I'm getting while running the Code in RStudio. iSQL Connection to the database is successful from the Linux machine.

I'm able to run the same R code above sucessfully from the Terminal option of Rstudio. It's not working only from the UI.

Does anyone know what could be the issue?

Mani14 avatar Aug 21 '23 14:08 Mani14

Thanks for the issue, @Mani14. Are you still seeing this issue?

simonpcouch avatar Jan 17 '24 17:01 simonpcouch