odbc
odbc copied to clipboard
r-dbi
Connect to ODBC databases (using the DBI interface)
to avoid escaping backslashes. ``` r requireNamespace("odbc") #> Loading required namespace: odbc DBI::dbQuoteIdentifier(new("OdbcConnection", quote = '"'), "a\\b")@.Data #> [1] "\"a\\\\b\"" ``` Created on 2022-06-12 by the [reprex package](https://reprex.tidyverse.org) (v2.0.1) This...
Hi Team, From customer ticket #75793 they note that they are seeing this error when connecting to a database using `DBI::dbConnect(odbc::odbc())`: > the logical functions, && and ||, now give...
In R 4.2.0, when dbConnect is called within RStudio using something like: ``` odbc::dbConnect(odbc::odbc(), "DSN") ``` In https://github.com/r-dbi/odbc/blob/dee7ae0cc2d3d0d10d54d412d5c448e7870414c9/R/Driver.R#L123, `as.character(expr[[1]])` will have values `[1] odbc :: dbConnect` and condition evaluates to...
### Issue Description and Expected Result `dbConnect()` returns error. ### Database MySQL Version: 8.0.20 ### Reproducible Example I removed the actual server address. ``` r library(DBI) library(odbc) dbConnect( drv =...
### Issue Description and Expected Result I am unable to create a successful ODBC connection to an IBM iSeries AS400/DB2 data source using R 4.2.0, (same goes for RStudio). The...
`dbBind` crashes (hard) when given multiple objects and one includes a cast from string to `datetimeoffset` (on mssql). Up front, the failing code is: ```r res
### Issue Description and Expected Result `dbExistsTable()` is brittle, success or failure to write data to a table should be reported by the database. Related: #465. As part of this...
```R library(DBI) library(odbc) mycon
### Issue Description and Expected Result dbConnect() establishes a connection to SQL Server with a wrong encoding. But only running code inside RStudio. When knitting the RMarkdown document everything works...
### Issue Description and Expected Result When trying to `odbc::dbWriteTable(conn = conn, name = "PM_transaction_categories", value = txn_cat, append = TRUE)` to a `VOLATILE TABLE` in `Teradata`, `odbc` throws ```Error...
