odbc

odbc copied to clipboard

I am having problems with parameterized queries and temp tables on SQL Server. I am using the RStudio Professional Driver for SQL Server. When I use unquoted inputs (e.g. 2...

nwstephens

Provide some basic check of driver config?

1

Is there some method you can run against a driver that would error if the path is incorrect? This would be useful for debugging driver install.

hadley

dbGetQuery() error use apache drill odbc

1

### `dbGetQuery()` returns [30038]Query execution error ### Database Database: DRILL, Drill Version: 01.16.0000 ### Reproducible Example [apache drill odbc](http://drill.apache.org/docs/configuring-odbc-on-linux/) Example: 1. connect ```R odbc_url

YuanZhencai

Use nanodbc::describe_parameters()

3

instead of relying on `SQLDescribeParams()`. This feels like the more robust way -- to adapt parameter types to what the client sends rather than to what the server thinks it...

krlmlr

Data gets truncated when special character example "ü" found while using Snowflake ODBC drivers with RStudio/R Terminal on Ubuntu 18.4/Centos 7.6/MacOS

2

### Issue Description and Expected Result Data gets truncated when special character example "ü" found while using Snowflake ODBC drivers with RStudio/R Terminal on Ubuntu 18.4/Centos 7.6/MacOS. When accessing data...

krishnavns

install odbc on PowerPC64 fails due to error in time_zone_libc.cc

1

### Issue Description and Expected Result We are trying to install `odbc` on a ppc64le/debian docker-container running on an IBM PowerPC 8. While installing via `install.packages("odbc")` we get this error...

Someone894

Password character escaping

2

### Issue Description and Expected Result dbConnect(..., PWD = ";fsdafasd;fasd")` is not escaping some character in password and it throwing the error: ``` Error: nanodbc/nanodbc.cpp:950: HY000: [unixODBC][RStudio][ODBC] (10360) Invalid connection...

galachad

Timestamp column with time zone for PostgreSQL

2

I found that `odbc` package creates `timestamp` columns `without time zone`, even if the time zone is present in R. This can shift time when reading and writing in different...

etiennebr

Asynchronous operation

1

It would be great to be able to interrupt a query that takes a long time to run and return records. For this it seems we need to look into...

krlmlr

DBI::dbListObjects(conn) and odbc::odbcListObjects() disagree

1

### Issue Description and Expected Result I would expect `DBI::dbListObject()` and `odbc::odbcListObjects()` to produce the same result. Or, at least, that `DBI::dbListObject()` would return schemas as well as tables. ```...

kevinushey