odbc icon indicating copy to clipboard operation
odbc copied to clipboard

Problem connecting to denodo

Open Mani14 opened this issue 1 year 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