odbc

odbc copied to clipboard

R 4.2.1: Unable to connect to DB2 database

1

### Issue Description and Expected Result Using R 4.2.1 it is not possible to connect to a DB2 database on Windows 10. It works in R 4.1.3 for what it...

mikghgit

Crash when querying non-existent table

4

### Issue Description and Expected Result I think this is essentially #386, but the solution there was a higher `odbc` version (1.2.2 -> 1.2.3, but I'm on 1.3.3). I kept...

jwhendy

dbWriteTable unable to append/overwrite data to Access

1

### Issue Description and Expected Result issues: ```r library(odbc) library(DBI) library(tidyverse) con

Ullix-xl

### Issue Description and Expected Result When calling `previewObject` even with a small row limit such as 50, it still takes a long time for the query to return when...

MariaSemple

Hi, I'm trying to connect to a SQL Server database through R using `{odbc}`. Like many others, I'm struggling. I started by installing the latest version of the Microsoft ODBC...

Worville

on Mac M1: Can't open lib: '...' file not found

2

### Issue Description and Expected Result While trying to connect through FreeTDS ```R cdw

DSLituiev

dbWriteTable unable to append data to existing Snowflake table

4

### Issue Description and Expected Result Related to #480. `dbWriteTable` returns an error message when appending data to an existing table in Snowflake. Error is specific to the Snowflake ODBC...

crossxwill

ODBC driver does not effectively take advantage of parallelization in Snowflake (INSERTs are sequential and slow)

2

### Issue Description and Expected Result RStudio ODBC driver does not effectively take advantage of parallelization in Snowflake as compared with SQL Server. INSERT functions in Snowflake are executed sequentially,...

tshaken

dbGetQuery no longer works with stored procedures

2

### 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

Troubleshooting ODBC connection to Redshift on Mac (Monterey M1): Error: nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Can't open lib '/opt/amazon/redshift/lib/libamazonredshiftodbc.dylib' : file not found

1

I am trying to connect to Redshift from the RStudio IDE on my Mac, and am stuck on this error: `Error: nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Can't open lib '/opt/amazon/redshift/lib/libamazonredshiftodbc.dylib' : file...

eamcvey