Closed dkalisch closed 1 month ago
Hello @dkalisch,
I tried to reproduce the problem with another database. In this case, a SQLite database.
Can you try placing the connection and reading of the table in the contents of the app_server
function?
Inside an observeEvent
, just for once, I :
I use a reactiveValues
to store my read and use it in my application.
app_server <- function(input, output, session) {
# Your application server logic
rv <- reactiveValues()
observeEvent(TRUE, once = TRUE, {
browser()
db <- DBI::dbConnect(RSQLite::SQLite(), "localdatabase")
rv$players <- dplyr::tbl(db, "players")
rv$players_filtered <- rv$players %>%
dplyr::filter(number > 10)
})
output$players_table <- renderTable({
rv$players_filtered
})
}
Closing as non reproducible.
Feel free to comment if you still have this issue 🤘
Describe the bug I try to build a shiny app with a database connection to a MSSQL Server via DBI and odic libraries. I can call the functions by hand correctly and they deliver the expected result. The package also builds without error. When I run the application with run_app() however, I get the error message:
Warning: Error in <Anonymous>: unable to find an inherited method for function ‘dbGetInfo’ for signature ‘"Microsoft SQL Server"’
for this line of code:closed_loans <- package_files.db %>%
in app_server.RTo Reproduce Steps to reproduce the behavior:
run_app()
Expected behavior A table of the requested data is shown in the app
session info
Additional context