Package: odbc 1.7.0.9000

Hadley Wickham

odbc: Connect to ODBC Compatible Databases (using the DBI Interface)

A DBI-compatible interface to ODBC databases.

Authors:Jim Hester [aut], Hadley Wickham [aut, cre], Oliver Gjoneski [aut], Simon Couch [aut], lexicalunit [cph], Google Inc. [cph], Posit Software, PBC [cph, fnd]

odbc_1.7.0.9000.tar.gz
odbc_1.7.0.9000.zip(r-4.7)odbc_1.7.0.9000.zip(r-4.6)odbc_1.7.0.9000.zip(r-4.5)
odbc_1.7.0.9000.tgz(r-4.6-x86_64)odbc_1.7.0.9000.tgz(r-4.6-arm64)odbc_1.7.0.9000.tgz(r-4.5-x86_64)odbc_1.7.0.9000.tgz(r-4.5-arm64)
odbc_1.7.0.9000.tar.gz(r-4.7-arm64)odbc_1.7.0.9000.tar.gz(r-4.7-x86_64)odbc_1.7.0.9000.tar.gz(r-4.6-arm64)odbc_1.7.0.9000.tar.gz(r-4.6-x86_64)
manual.pdf |manual.html✨
card.svg |card.png
odbc/json (API)
NEWS

# Install 'odbc' in R:
install.packages('odbc', repos = c('https://zeehio.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/r-dbi/odbc/issues

Pkgdown/docs site:https://odbc.r-dbi.org

Uses libs:
  • unixodbc– ODBC Driver Manager library for Unix
  • c++– GNU Standard C++ Library v3

On CRAN:

Conda:

unixodbccpp

13.11 score 30 packages 3.5k scripts 156k downloads 2 mentions 49 exports 12 dependencies

Last updated from:a2dfdb7b9c (on databricks-config-file). Checks:11 ERROR, 1 OK, 1 FAIL. Indexed: no.

TargetResultTimeFilesSyslog
linux-devel-arm64ERROR180
linux-devel-x86_64ERROR180
source / vignettesOK304
linux-release-arm64ERROR171
linux-release-x86_64ERROR195
macos-release-arm64ERROR216
macos-release-x86_64ERROR474
macos-oldrel-arm64ERROR171
macos-oldrel-x86_64ERROR621
windows-develERROR202
windows-releaseERROR173
windows-oldrelERROR196
wasm-releaseFAIL131

Exports:databricksdbAppendTabledbBegindbBinddbClearResultdbColumnInfodbCommitdbConnectdbDataTypedbDisconnectdbExecutedbExistsTabledbFetchdbGetInfodbGetQuerydbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsValiddbListFieldsdbListTablesdbQuoteIdentifierdbQuoteStringdbRemoveTabledbRollbackdbSendQuerydbSendStatementdbWriteTableisTempTableodbcodbcDataTypeodbcEditDriversodbcEditSystemDSNodbcEditUserDSNodbcListColumnsodbcListConfigodbcListDataSourcesodbcListDriversodbcListObjectsodbcListObjectTypesodbcPreviewObjectodbcSetTransactionIsolationLevelquote_valueredshiftshowsnowflakesqlCreateTablesqlData

Dependencies:bitbit64blobcliDBIgluehmslifecyclepkgconfigRcpprlangvctrs

Benchmarks

Rendered frombenchmarks.Rmdusingknitr::rmarkdownon May 19 2026.

Last update: 2023-12-14
Started: 2023-12-12

Developing odbc

Rendered fromdevelop.Rmdusingknitr::rmarkdownon May 19 2026.

Last update: 2026-05-12
Started: 2023-12-14

Installing and Configuring Drivers

Rendered fromsetup.Rmdusingknitr::rmarkdownon May 19 2026.

Last update: 2024-02-23
Started: 2023-12-12

Readme and manuals

Help Manual

Help pageTopics
Helper for Connecting to Databricks via ODBCdatabricks DatabricksOdbcDriver-class dbConnect,DatabricksOdbcDriver-method
Convenience functions for reading/writing DBMS tablesdbAppendTable,OdbcConnection-method DBI-tables dbWriteTable,OdbcConnection,character,data.frame-method dbWriteTable,OdbcConnection,Id,data.frame-method dbWriteTable,OdbcConnection,SQL,data.frame-method sqlCreateTable,OdbcConnection-method
List remote tables and fields for an ODBC connectiondbListTables,OdbcConnection-method
Helper method used to determine if a table identifier is that of a temporary table.isTempTable isTempTable,OdbcConnection,Id-method isTempTable,OdbcConnection,SQL-method
Connect to a database via an ODBC driverdbConnect dbConnect,OdbcDriver-method odbc
Connecting to Snowflake via ODBCdbExistsTableForWrite,Snowflake,character-method odbcConnectionColumns,Snowflake,character-method
Return the corresponding ODBC data type for an R objectodbcDataType odbcDataType,ACCESS-method odbcDataType,ANY-method odbcDataType,BigQuery-method odbcDataType,Hive-method odbcDataType,Impala-method odbcDataType,Microsoft SQL Server-method odbcDataType,MySQL-method odbcDataType,NetezzaSQL-method odbcDataType,Oracle-method odbcDataType,PostgreSQL-method odbcDataType,Redshift-method odbcDataType,Snowflake-method odbcDataType,Spark SQL-method odbcDataType,SQLite-method odbcDataType,Teradata-method odbcDataType,Vertica Database-method
List columns in an object.odbcListColumns
List locations of ODBC configuration filesodbcEditDrivers odbcEditSystemDSN odbcEditUserDSN odbcListConfig
List Configured Data Source NamesodbcListDataSources
List Configured ODBC DriversodbcListDrivers
List objects in a connection.odbcListObjects
Return the object hierarchy supported by a connection.odbcListObjectTypes
Preview the data in an object.odbcPreviewObject
Set the Transaction Isolation Level for a ConnectionodbcSetTransactionIsolationLevel
Quote special character when connectingquote_value
Helper for Connecting to Redshift via ODBCdbConnect,RedshiftOdbcDriver-method redshift RedshiftOdbcDriver-class
Helper for connecting to Snowflake via ODBCdbConnect,SnowflakeOdbcDriver-method snowflake SnowflakeOdbcDriver-class