odbc
odbc copied to clipboard
r-dbi
Connect to ODBC databases (using the DBI interface)
### Issue Description and Expected Result `dbListTable` shows garbled Japanese table names. ### Database SQL Server 2014 RTM SQL Azure 12.0.2000.8 ### Reproducible Example With odbc package version 1.3.2, The...
### Issue Description and Expected Result dbGetQuery fails translating an Unicode special character stored in NVARCHAR(MAX) column in SQL Server with error message: Error in result_fetch(res@ptr, n) : wstring_convert::to_bytes ###...
## Schema and example data ``` create table Custom.WipForecast ( OperationId bigint not null StartTimelineMinuteId datetime2 not null, ForecastWindowMinutes bigint not null, ForecastValue decimal(18, 2) not null, ModelName nvarchar(50) )...
 When you attempt to preview a table from a different catalog than the one used to create the initial connection, you will get a ```r Error in new_result(connection@ptr, statement,...
### Issue Description and Expected Result Upgraded from odbc 1.3.0 to 1.3.1 and output after connection to Redshift has changed. With `1.3.0`, running the following in RStudio (1.4.1106) yields a...
The RStudio Pro Driver for Redshift supports spectrum tables; however, the view icon does not show up in the IDE. I would expect to see the view icon next to...
DBI::dbWriteTable doesn't use "VARCHAR(16777216)" for a field.type when the input column is a long string. I'm getting this error when writing to snowflake via `DBI::dbConnect(odbc::odbc()...` ``` Error in result_insert_dataframe(rs@ptr, values,...
A table (df_table) exists in two Snowflake databases, dev and prod. Both dev and prod have schemas of the same name (test) which house the tables. The table is successfully...
in the README. See https://github.com/r-dbi/RPostgres/issues/240#issuecomment-821512267 for a list of pros and cons. Also filed as https://github.com/rstudio/db.rstudio.com/issues/138.
### Connecting to Azure SQL database using access token via pre-connect connection attributes Is it possible to set pre-connect attributes on a connection using r odbc? I want to use...
