odbc
odbc copied to clipboard
r-dbi
Connect to ODBC databases (using the DBI interface)
The removes the character constraints on R data types mapped to `VARBINARY` and `VARCHAR` columns by the `odbcDataType.Snowflake()` function. Character strings in both Snowflake and R are not limited to...
*Hey everybody, long time no chat! Is anyone going to an in-person R or INFORMS conference any time soon? I think I owe many of you a beer or something...
When using "SQL Server" driver you can omit the `trusted_connection` argument and it will assume `trusted_connection = "True"` (although this is not documented): ```r dbConnect( odbc(), driver = "SQL Server",...
Some of my shiny app users can not login to the database via app but they could from their windows machine via SQL management studio. I'm using the `odbc` package...
### Issue Description and Expected Result Can't compile odbc package for RStudio in FreeBSD ### Database No database involved ### Reproducible Example The odbc R package is installed, but when...
### Issue Description and Expected Result When querying a table with char columns using LATIN character set, I am not able to retrieve the data when the statement contains non-standard...
I have used `dplyr` and `odbc` to generate a query, and I do not want to collect it into R memory, instead I want to write it back into the...
### Issue Description and Expected Result R assumes that all integers are SQL_DECIMAL(38,0). Can integers in Snowflake be translated as integers in R and Big Integers in Snowflake translated as...
Excessive RAM memory consumption on Windows and Linux with dbWriteTable (std::bad_alloc on Windows)
### Issue Description and Expected Result On Windows with `odbc` version 1.3.2, `DBI` 1.1.1 and R 4.1.0 and also with R 3.63 as well as on Ubuntu with R 3.6.3...
I get a bad_alloc error when trying to connect to a DB2 database (called ODS below) via 64bit DB2 drivers via 64bit R/Rstudio installed in Linux (Ubuntu 18.04) ## Code...
