odbc

odbc copied to clipboard

Error in result_fetch(res@ptr, n) : wstring_convert::to_bytes with odbc 1.2.3 +

11

### Issue Description and Expected Result When querying tables with long text entries I get the error `Error in result_fetch(res@ptr, n) : wstring_convert::to_bytes` when querying the table with select *,...

smmurphy

odbc may return garbaged letters for varchar type when driver changes encoding

5

## Issue Description and Expected Result odbc returns garbaged letters for the following SQL: `"select '你好' as '中文'"` while RODBC works expectedly ### Database - DB: SQL Server 2017 -...

shrektan

Invalid connection string attribute on MS SQL 14 with ODBC Driver 17

1

### Issue Description and Expected Result I have connected to a wide range of MS SQL Server without problems, but I have a particular problem with a given MS SQL...

GeiserX

how do i close a connection after i finish running the script?

1

### Issue Description and Expected Result how do i close a connection after i finish running the script?

FinotiLucas

Encode non-ASCII Column Names to UTF-8

4

Closes #430 Closes #432 # Code ``` r x

shrektan

### Issue Description and Expected Result I'm using odbc on a Windows 10 machine to connect R to our Oracle datawarehouse. I can connect and use dplyr in the console...

crazybilly

Encoding of Azure Data Warehouse secret key leads to base-64 error

1

### Issue Description and Expected Result Using dbExecute to run a query that contains a storage account key fails with _Error: nanodbc/nanodbc.cpp:1617: 42000: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The...

alastairmatheson

### Issue Description and Expected Result Incorrect function signature for `sqlCreateTable` in `R/db.R` The following snippet is the signature given by odbc package: ``` setMethod("sqlCreateTable", "Teradata", function(con, table, fields, field.types...

adithya604

Avoid querying column types from the database in dbWriteTable() and dbAppendTable()

9

### Issue Description and Expected Result `dbWriteTable()` on SQL Server 12.xx fails with BLOB columns **if the table name is given in quotes**. (I spent too much time isolating this.)...

krlmlr

### Issue Description and Expected Result I've just install R version 4.0.3 (until last week I was using R 3.6) with DBI 1.1.1 and I'm facing a new error that...

gitkatdev