Package: odbc 1.5.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], lexicalunit [cph], Google Inc. [cph], Posit Software, PBC [cph, fnd]

odbc_1.5.0.9000.tar.gz
odbc_1.5.0.9000.zip(r-4.5)odbc_1.5.0.9000.zip(r-4.4)odbc_1.5.0.9000.zip(r-4.3)
odbc_1.5.0.9000.tgz(r-4.4-x86_64)odbc_1.5.0.9000.tgz(r-4.4-arm64)odbc_1.5.0.9000.tgz(r-4.3-x86_64)odbc_1.5.0.9000.tgz(r-4.3-arm64)
odbc_1.5.0.9000.tar.gz(r-4.5-noble)odbc_1.5.0.9000.tar.gz(r-4.4-noble)
odbc.pdf |odbc.html✨
odbc/json (API)
NEWS

# Install 'odbc' in R:

install.packages('odbc', repos = c('https://r-dbi.r-universe.dev', 'https://cloud.r-project.org'))

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

Uses libs:

unixodbc– ODBC Driver Manager library for Unix
c++– GNU Standard C++ Library v3

On CRAN:

database odbc

51 exports 387 stars 7.76 score 12 dependencies 18 dependents 2 mentions 4.6k scripts 86.4k downloads

Last updated 2 days agofrom:5f51af716b. Checks:OK: 7 NOTE: 2. Indexed: yes.

Target	Result	Date
Doc / Vignettes	OK	Sep 05 2024
R-4.5-win-x86_64	NOTE	Sep 05 2024
R-4.5-linux-x86_64	NOTE	Sep 05 2024
R-4.4-win-x86_64	OK	Sep 05 2024
R-4.4-mac-x86_64	OK	Sep 05 2024
R-4.4-mac-aarch64	OK	Sep 05 2024
R-4.3-win-x86_64	OK	Sep 05 2024
R-4.3-mac-x86_64	OK	Sep 05 2024
R-4.3-mac-aarch64	OK	Sep 05 2024

Exports:databricks dbAppendTable dbBegin dbBind dbClearResult dbColumnInfo dbCommit dbConnect dbDataType dbDisconnect dbExecute dbExistsTable dbFetch dbGetInfo dbGetQuery dbGetRowCount dbGetRowsAffected dbGetStatement dbHasCompleted dbIsValid dbListFields dbListTables dbQuoteIdentifier dbQuoteString dbRemoveTable dbRollback dbSendQuery dbSendStatement dbWriteTable isTempTable odbc odbcConnectionActions odbcConnectionColumns odbcConnectionIcon odbcDataType odbcEditDrivers odbcEditSystemDSN odbcEditUserDSN odbcListColumns odbcListConfig odbcListDataSources odbcListDrivers odbcListObjects odbcListObjectTypes odbcPreviewObject odbcSetTransactionIsolationLevel quote_value show snowflake sqlCreateTable sqlData

Dependencies:bit bit64 blob cli DBI glue hms lifecycle pkgconfig Rcpp rlang vctrs

Benchmarks

Rendered frombenchmarks.Rmdusingknitr::rmarkdownon Sep 05 2024.

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

Developing odbc

Rendered fromdevelop.Rmdusingknitr::rmarkdownon Sep 05 2024.

Last update: 2024-07-17
Started: 2023-12-14

Installing and Configuring Drivers

Rendered fromsetup.Rmdusingknitr::rmarkdownon Sep 05 2024.

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

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Helper for Connecting to Databricks via ODBC	databricks DatabricksOdbcDriver-class dbConnect,DatabricksOdbcDriver-method
Convenience functions for reading/writing DBMS tables	dbAppendTable,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 connection	dbListTables,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 driver	dbConnect dbConnect,OdbcDriver-method odbc
Connecting to Snowflake via ODBC	dbExistsTableForWrite,Snowflake,character-method odbcConnectionColumns_,Snowflake,character-method
Return the corresponding ODBC data type for an R object	odbcDataType odbcDataType,ACCESS-method odbcDataType,ANY-method odbcDataType,BigQuery-method odbcDataType,Hive-method odbcDataType,Impala-method odbcDataType,Microsoft SQL Server-method odbcDataType,MySQL-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 files	odbcEditDrivers odbcEditSystemDSN odbcEditUserDSN odbcListConfig
List Configured Data Source Names	odbcListDataSources
List Configured ODBC Drivers	odbcListDrivers
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 Connection	odbcSetTransactionIsolationLevel
Quote special character when connecting	quote_value
Helper for connecting to Snowflake via ODBC	dbConnect,Snowflake-method snowflake