New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Problem connecting to denodo #596

Open

Mani14 opened this issue Aug 21, 2023 · 1 comment

Labels

reprex

Mani14 commented Aug 21, 2023 •

edited by hadley

Loading

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?

Collaborator

simonpcouch commented Jan 17, 2024

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

hadley added the reprex label

hadley changed the title ~~RODBC Connection Issue~~ Problem connecting to denodo

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment