r-dbi/odbc

View on GitHub

Connect to ODBC databases (using the DBI interface)

Stars: 416
Forks: 118
Open beginner issues: 0
Indexed issues: 66
Avg merge: 4d 3h
Merged PRs (30d): 7

Dominant language: C++
License: No license data
Last GitHub push: Sep 16, 2026
Latest indexed: Sep 20, 2026
Contributing guide: No contributing guide
Code of conduct: Code of conduct
Beginner labels: No beginner labels indexed

Beginner friendly Everything

Open All

66 open issues indexed

override built-in connection arguments case-insensitively Open

Difficulty 3/5 1-2 days Newbie friendliness 55/100

r-dbi/odbc#1034 · Opened Aug 28, 2026
New upstream nanodbc Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

r-dbi/odbc#1027 · Opened Aug 21, 2026
`BINARY` columns silently truncated to `n mod 1024` bytes (Databricks/Spark ODBC; `pyodbc` unaffected) Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

r-dbi/odbc#1024 · 1 comment · Opened Aug 20, 2026
Transient `ReauthenticationRequest Signal Exception` Error on Posit Workbench with Snowflake managed credentials Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

r-dbi/odbc#1017 · Opened Jul 6, 2026
New Microsoft Fabric ODBC Driver Support Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

r-dbi/odbc#992 · Opened Feb 27, 2026
test failures with SQL Server + Posit Pro Drivers Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

r-dbi/odbc#974 · 6 comments · Opened Dec 1, 2025
RE: Performance issue to connect to an Oracle database using Oracle's OEM driver Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

r-dbi/odbc#970 · 1 reaction · Opened Nov 25, 2025
`varchar()` measures characters instead of bytes, causing truncation with multibyte UTF-8 strings (SQL Server) Open

Difficulty 1/5 1-3 hours Newbie friendliness 55/100

r-dbi/odbc#960 · 1 comment · Opened Oct 29, 2025
Misleading documentation of `encoding` prameter Open

Difficulty 2/5 Half a day Newbie friendliness 48/100

r-dbi/odbc#944 · Opened Sep 8, 2025
Support Databricks Lakebase connections Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

r-dbi/odbc#935 · 1 reaction · Opened Aug 15, 2025
Writing Tables to Non-Unity Catalog Databricks using databricks ODBC driver Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

r-dbi/odbc#932 · 1 comment · Opened Jul 16, 2025
Support for custom env var when passing user token in `DBI::dbConnect(odbc::databricks())` Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

r-dbi/odbc#929 · Opened Jul 10, 2025
Oracle copy_to errors with index Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

r-dbi/odbc#912 · 1 comment · Opened Apr 7, 2025
Calling `DBI::dbConnect(odbc::databricks())` a second time fails with `Error in driver_config$path ` on MacOS Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

r-dbi/odbc#901 · 4 comments · 1 reaction · Opened Mar 5, 2025
`dbReadTableArrow` is much slower than `dbReadTable` Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

r-dbi/odbc#884 · 2 comments · Opened Jan 21, 2025
Add additional cloud provider driver "helper" functions Open

feature

Difficulty 5/5 Over a week Newbie friendliness 25/100

r-dbi/odbc#878 · 3 comments · 1 reaction · Opened Jan 6, 2025
Providing a path to a driver directly? Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

r-dbi/odbc#874 · 6 comments · Opened Dec 21, 2024
dplyr::copy_to() performance with odbc 1.5.0 Open

Difficulty 4/5 3-5 days Newbie friendliness 20/100

r-dbi/odbc#862 · 5 comments · 1 reaction · Opened Nov 11, 2024
Document `EnableQueryResultDownload` for `databricks()` Open

Difficulty 2/5 1-3 hours Newbie friendliness 52/100

r-dbi/odbc#856 · 8 comments · Opened Oct 17, 2024
Include additional details in Databricks user agent Open

Difficulty 2/5 1-3 hours Newbie friendliness 45/100

r-dbi/odbc#831 · Opened Jul 17, 2024
Clarification on `dbConnect()` documentation Open

documentation

Difficulty 2/5 1-3 hours Newbie friendliness 42/100

r-dbi/odbc#877 · 4 comments · Opened May 13, 2024
consider testing DBs on macOS Open

databricks snowflake upkeep

Difficulty 3/5 1-2 days Newbie friendliness 45/100

r-dbi/odbc#783 · 2 reactions · Opened Apr 8, 2024
Include synonyms in `odbcListObjects()`, `dbListTables()`, and the Connections Pane Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

r-dbi/odbc#779 · 1 comment · Opened Apr 2, 2024
DBI::dBDisconnect() with ms-access Open

msaccess

Difficulty 4/5 3-5 days Newbie friendliness 35/100

r-dbi/odbc#757 · 1 comment · Opened Feb 7, 2024
revisit Impala binary type Open

impala

Difficulty 3/5 1-2 days Newbie friendliness 35/100

r-dbi/odbc#754 · 1 comment · Opened Jan 30, 2024
SQL Server error messages do not always lead to errors in R Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

r-dbi/odbc#745 · 7 comments · Opened Jan 19, 2024
Make DBItest tests more consistent Open

upkeep

Difficulty 3/5 1-2 days Newbie friendliness 35/100

r-dbi/odbc#723 · 1 comment · Opened Jan 11, 2024
Add support for naming tables with `I()` Open

Difficulty 4/5 3-5 days Newbie friendliness 32/100

r-dbi/odbc#708 · 4 comments · Opened Dec 22, 2023
Automate `httpPath` by pulling from Databricks REST API Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

r-dbi/odbc#689 · 6 comments · Opened Dec 18, 2023
`CURRENT_TIMESTAMP` returns offset in time despite specifying `timezone =` in `dbConnect()` with Oracle Open

oracle

Difficulty 4/5 3-5 days Newbie friendliness 42/100

r-dbi/odbc#681 · 5 comments · Opened Dec 14, 2023
`setMethod("sqlData", "OdbcConnection")` should use `inherits` Open

upkeep

Difficulty 2/5 1-3 hours Newbie friendliness 35/100

r-dbi/odbc#673 · 1 comment · Opened Dec 13, 2023
Provide helper for SQLite Open

feature sqlite

Difficulty 5/5 Over a week Newbie friendliness 25/100

r-dbi/odbc#659 · 1 comment · Opened Dec 7, 2023
Support for automatic credential refresh with supported drivers Open

r-dbi/odbc#653 · 1 comment · 1 reaction · 1 assignee · Opened Dec 7, 2023
Switch to cpp11 Open

upkeep

Difficulty 5/5 Over a week Newbie friendliness 15/100

r-dbi/odbc#619 · Opened Nov 19, 2023
Database connection fails due to error with SQLAllocHandle Open

db2 encoding 🔤

Difficulty 4/5 3-5 days Newbie friendliness 25/100

r-dbi/odbc#597 · 6 comments · Opened Aug 22, 2023
Problem connecting to denodo Open

reprex

Difficulty 4/5 3-5 days Newbie friendliness 20/100

r-dbi/odbc#596 · 1 comment · Opened Aug 21, 2023
Enumerate procedures in connections pane Open

feature

Difficulty 4/5 3-5 days Newbie friendliness 35/100

r-dbi/odbc#578 · Opened Jun 11, 2023
Update vendored cctz Open

upkeep

Difficulty 4/5 3-5 days Newbie friendliness 25/100

r-dbi/odbc#568 · Opened Apr 24, 2023
Allow the user to override parameter metadata Open

bug encoding 🔤 mssql

Difficulty 5/5 Over a week Newbie friendliness 30/100

r-dbi/odbc#518 · 13 comments · Opened Nov 4, 2022
Query timeout option (SQL_ATTR_QUERY_TIMEOUT) Open

feature

Difficulty 4/5 3-5 days Newbie friendliness 38/100

r-dbi/odbc#515 · 16 comments · 1 reaction · Opened Oct 20, 2022
Error when nvarchar(MAX) and/or varbinary(MAX) are in the SELECT statement while using bind parameters with multiple sets of values Open

bug mssql

Difficulty 4/5 3-5 days Newbie friendliness 32/100

r-dbi/odbc#490 · Opened Apr 5, 2022
clarify 'immediate=' verbiage Open

documentation

Difficulty 3/5 1-2 days Newbie friendliness 45/100

r-dbi/odbc#484 · 1 comment · Opened Feb 19, 2022
odbc - sending query with non-standard characters fails to retrieve data Open

bug encoding 🔤 teradata

Difficulty 4/5 3-5 days Newbie friendliness 35/100

r-dbi/odbc#479 · Opened Dec 14, 2021
Discuss when using specialized DBI backends is preferable to odbc Open

documentation

r-dbi/odbc#470 · 1 assignee · Opened Sep 25, 2021
Limit the Connections Pane to only what the end-user has access to Open

connection-pane :window: feature

Difficulty 5/5 Over a week Newbie friendliness 20/100

r-dbi/odbc#447 · 7 comments · 2 reactions · Opened Mar 22, 2021
Error in result_fetch(res@ptr, n) : wstring_convert::to_bytes with odbc 1.2.3 + Open

bug postgres

Difficulty 4/5 3-5 days Newbie friendliness 35/100

r-dbi/odbc#427 · 12 comments · 1 reaction · Opened Dec 29, 2020
Encoding of Azure Data Warehouse secret key leads to base-64 error Open

azure bug

Difficulty 4/5 3-5 days Newbie friendliness 25/100

r-dbi/odbc#410 · 1 comment · Opened Dec 9, 2020
dbGetQuery() error use apache drill odbc Open

bug drill

Difficulty 3/5 1-2 days Newbie friendliness 35/100

r-dbi/odbc#380 · 2 comments · Opened Jul 22, 2020
Use nanodbc::describe_parameters() Open

feature

Difficulty 4/5 3-5 days Newbie friendliness 35/100

r-dbi/odbc#373 · 3 comments · Opened Jun 10, 2020
Cannot read unicode from "PostgreSQL Unicode(x64)" Open

bug encoding 🔤 postgres

Difficulty 4/5 3-5 days Newbie friendliness 35/100

r-dbi/odbc#301 · Opened Sep 26, 2019

r-dbi/odbc

Get new issues in your inbox