odbc

odbc copied to clipboard

revisit Impala binary type

1

See: https://github.com/r-dbi/odbc/blob/14ca101bd1f1922f6e093b06c08dfb921d3451b7/R/driver-impala.R#L4 May have been resolved since the comment was introduced.

simonpcouch

update Oracle setup docs

1

Some notes-to-self after an afternoon trying to make this happen... the following from Jim remains true: https://github.com/r-dbi/odbc/blob/e8b68fa5de44bf3d3cd7cfedb204bf8f7c260f16/vignettes/develop.Rmd#L203 😝 Oracle Cloud Free as a quick setup to test against is a...

simonpcouch

SQL Server error messages do not always lead to errors in R

7

### Issue Description and Expected Result `dbExecute()` and similar commands (like `dbGetQuery()`, `dbWriteTable()`) do not always raise an error when a `throw` or `raiserror` occurs in SQL Server. ### Database...

jordivandooren

Oracle Connection Names Set as "Default" in RStudio Connection Panel

1

### Issue Description and Expected Result The current implementation of the odbc package sets the name of every database connection to "Default" when connecting to Oracle databases at work. This...

woodtho

Currently when determining the structure of the object tree for the connection, [we call](https://github.com/r-dbi/odbc/blob/main/R/connection-pane.R#L34) odbcConnectionCatalogs/Schemas just to verify if there is a non-trivial result. For example, `if length(odbcConnectionSchemas(conn)) then `....

detule

hadley

Problem connecting to denodo

1

```R library(odbc) con

Mani14

Provide helper for SQLite

1

Supported arguments: ``` Database (string) name of SQLite2/3 database file; default empty PWD (string) password when built with SEE support; default empty Timeout (integer) lock time out in milliseconds; default...

hadley

Make DBItest tests more consistent

1

So we're skipping the same core tests on all backends. And gate behind standard env var so it's easy to turn off if desired.

hadley

Add support for naming tables with `I()`

4

And eliminate double dispatch for `dbExistsTable()` and friends ```R setMethod( "dbExistsTable", c("OdbcConnection"), function(conn, name, ...) { if (is(name, "SQL") || inherits(x, "AsIs")) { # converts to an Id object name

hadley