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✨
DESCRIPTION |NEWS
card.svg |card.png
odbc/json (API)

# Install 'odbc' in R:
install.packages('odbc', repos = c('https://ar-puuk.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:

databaseodbcunixodbccpp

16.67 score 414 stars 27 packages 3.6k scripts 155k downloads 2 mentions 49 exports 12 dependencies

Last updated from:4794238a1b. Checks:11 NOTE, 1 OK, 1 FAIL. Indexed: no.

TargetResultTimeFilesSyslog
linux-devel-arm64NOTE230
linux-devel-x86_64NOTE194
source / vignettesOK267
linux-release-arm64NOTE188
linux-release-x86_64NOTE182
macos-release-arm64NOTE192
macos-release-x86_64NOTE381
macos-oldrel-arm64NOTE135
macos-oldrel-x86_64NOTE368
windows-develNOTE314
windows-releaseNOTE431
windows-oldrelNOTE406
wasm-releaseFAIL136

Exports:databricksdbAppendTabledbBegindbBinddbClearResultdbColumnInfodbCommitdbConnectdbDataTypedbDisconnectdbExecutedbExistsTabledbFetchdbGetInfodbGetQuerydbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsValiddbListFieldsdbListTablesdbQuoteIdentifierdbQuoteStringdbRemoveTabledbRollbackdbSendQuerydbSendStatementdbWriteTableisTempTableodbcodbcDataTypeodbcEditDriversodbcEditSystemDSNodbcEditUserDSNodbcListColumnsodbcListConfigodbcListDataSourcesodbcListDriversodbcListObjectsodbcListObjectTypesodbcPreviewObjectodbcSetTransactionIsolationLevelquote_valueredshiftshowsnowflakesqlCreateTablesqlData

Dependencies:bitbit64blobcliDBIgluehmslifecyclepkgconfigRcpprlangvctrs

Developing odbc
Posit Professional Drivers | Drivers | Databases | PostgreSQL | MySQL | SQL Server test setup | SQLite | Oracle | On MacOS | On Linux | Snowflake | Amazon Redshift | RODBC
Rendered fromdevelop.Rmdusingknitr::rmarkdown

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

Installing and Configuring Drivers
Installation | Windows | MacOS | Linux - Debian / Ubuntu | Driver configuration | Data source configuration | Debugging driver and data source configurations | Setting ODBCSYSINI
Rendered fromsetup.Rmdusingknitr::rmarkdown

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

Benchmarks
Setup | Writing | Reading
Rendered frombenchmarks.Rmdusingknitr::rmarkdown

Last update: 2023-12-14
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