odbc
odbc copied to clipboard
r-dbi
Connect to ODBC databases (using the DBI interface)
An ODBC connection from R can either create the connection string manually via function arguments to `odbc()` or pass in a DSN: ```r con
Closes #221. This PR modifies/adds SQL Server methods for `dbListTables()`, `dbExistsTable()`, and `odbcListObjects()` that include synonyms in output. This also means that synonyms will show up in the Connections pane....
### Issue Description and Expected Result When using `package:odbc` with Oracle's OEM driver, the connection is excessively long to establish. Once established, the Connection Pane seems to load objects forever...
Hi, I am currently able to connect to a MS SQL Server and read tables with CLI. However, I am still not able to make it work on R due...
Sets up Actions to test Snowflake.❄️ ~Will need to wait until we have credentials for a runner account to start running tests.~ Closes #563.
Since it seems like we have quite a few issues related to it.
Some machinery to close #651. Opening as draft as I've yet to integrate this into any functionality yet. Would `configure_spark()` be best situated as: 1) An exit handler on `dbConnect()`...
Hello, I updated R from MS R Open and R 4.0.1 to R 4.3.1. Since then, I have trouble connecting to DB2 databases via the 'odbc' package (Version 1.3.5). I...
After run the dbDisconnect with a ms-access connection for the first time in a session ever works well. But when call the connection again it not work more and don't...
Using Oracle, `CURRENT_TIMESTAMP` returns a date-time with an offset in time despite specifying `timezone =` in `dbConnect()`: ```r library(DBI) Sys.setenv(TZ = "Europe/Paris") Sys.time() # [1] "2023-12-14 18:01:37 CET" query