odbc
odbc copied to clipboard
Problem connecting to denodo
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?