Package: odbc 1.5.0.9000
![](https://github.com/r-dbi/odbc/raw/HEAD/man/figures/logo.png)
odbc: Connect to ODBC Compatible Databases (using the DBI Interface)
A DBI-compatible interface to ODBC databases.
Authors:
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
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:databricksdbAppendTabledbBegindbBinddbClearResultdbColumnInfodbCommitdbConnectdbDataTypedbDisconnectdbExecutedbExistsTabledbFetchdbGetInfodbGetQuerydbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsValiddbListFieldsdbListTablesdbQuoteIdentifierdbQuoteStringdbRemoveTabledbRollbackdbSendQuerydbSendStatementdbWriteTableisTempTableodbcodbcConnectionActionsodbcConnectionColumnsodbcConnectionIconodbcDataTypeodbcEditDriversodbcEditSystemDSNodbcEditUserDSNodbcListColumnsodbcListConfigodbcListDataSourcesodbcListDriversodbcListObjectsodbcListObjectTypesodbcPreviewObjectodbcSetTransactionIsolationLevelquote_valueshowsnowflakesqlCreateTablesqlData
Dependencies:bitbit64blobcliDBIgluehmslifecyclepkgconfigRcpprlangvctrs
Benchmarks
Rendered frombenchmarks.Rmd
usingknitr::rmarkdown
on Sep 05 2024.Last update: 2023-12-14
Started: 2023-12-12
Developing odbc
Rendered fromdevelop.Rmd
usingknitr::rmarkdown
on Sep 05 2024.Last update: 2024-07-17
Started: 2023-12-14
Installing and Configuring Drivers
Rendered fromsetup.Rmd
usingknitr::rmarkdown
on Sep 05 2024.Last update: 2024-02-23
Started: 2023-12-12
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 |