odbc
odbc copied to clipboard
r-dbi
Connect to ODBC databases (using the DBI interface)
### Issue Description and Expected Result Materialized Views in PostgreSQL show in the connections pane, but columns aren't displayed in the connections pane and no columns are returned by `odbcListColumns`....
### Issue Description and Expected Result `dbGetQuery()` gets "Error in result_fetch(res@ptr, n, ...) : Incomplete multibyte sequence" when accessing a MS Access database with GBK/CP936 (Chinese) encoding. > It looks...
### Issue Description `dbWriteTable()` returns error when attempting to write out data using Impala backend. An interesting error occurs as it appears the parameter placeholder, ?, is not recognized. Ideally...
**Steps to reproduce:** * Connect to some postgre database in windows using connection string with driver `PostgreSQL Unicode(x64)`. Optionally, specify the encoding to be UTF-8 in the `dbConnect` argument. Example:...
When I create a temporary table on Hive, the table name is called `values__tmp__table__1`. I would expect the table to be called `mtcars`. ```dbWriteTable(con, "mtcars", mtcars, temporary = TRUE)``` 
Hive uses C-style escape for string literals, so the result of this pseudo reprex should be `'it\'s ok'`. (Sorry for not providing the actual reprex...) ```r # `con` is a...
It was reported by a user that appending a semi-colon to the end of the `ON COMMIT PRESERVE ROWS` line fixes an issue he has been getting: https://github.com/tidyverse/dplyr/issues/3531. Specifically, the...
### Issue Description and Expected Result Teradata says: The data types in the in connection pane need to be improved. Varchar should be Varchar(6). Timestamp should be Timestamp TZ. ###...
### Issue Description and Expected Result Previewing tables via the connections pane in R Studio Server leads to an "R session error": Within the connections pane... ...pressing the icon on...
### dbColumnInfo function does not provide the datatype name of the column ### PostgreSQL 9.3 ### Using JDBC drivers On calling dbColumnInfo using JDBC drivers, the following column are returned...
