Package: RODBC 1.3-26
Brian Ripley
RODBC: ODBC Database Access
An ODBC database interface.
Authors:
RODBC_1.3-26.tar.gz
RODBC_1.3-26.tar.gz(r-4.5-noble)RODBC_1.3-26.tar.gz(r-4.4-noble)
RODBC.pdf |RODBC.html✨
RODBC/json (API)
| # Install 'RODBC' in R: |
| install.packages('RODBC', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org')) |
This package does not link to any Github/Gitlab/R-forge repository. No issue tracker or development information is available.
Last updated 3 months agofrom:e1a6307002. Checks:3 OK. Indexed: yes.
| Target | Result | Latest binary |
|---|---|---|
| Doc / Vignettes | OK | Mar 12 2025 |
| R-4.5-linux-x86_64 | OK | Mar 12 2025 |
| R-4.4-linux-x86_64 | OK | Mar 12 2025 |
Exports:getSqlTypeInfoodbcClearErrorodbcCloseodbcCloseAllodbcConnectodbcDataSourcesodbcDriverConnectodbcEndTranodbcFetchRowsodbcGetErrMsgodbcGetInfoodbcQueryodbcReConnectodbcSetAutoCommitodbcTablesodbcUpdatesetSqlTypeInfosqlClearsqlColumnssqlCopysqlCopyTablesqlDropsqlFetchsqlFetchMoresqlGetResultssqlPrimaryKeyssqlQuerysqlSavesqlTablessqlTypeInfosqlUpdate
Dependencies:
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| ODBC Database Connectivity | RODBC-package RODBC |
| Low-level ODBC functions | odbcClearError odbcFetchRows odbcGetErrMsg odbcQuery odbcTables |
| ODBC Close Connections | close.RODBC odbcClose odbcCloseAll |
| ODBC Open Connections | odbcConnect odbcDriverConnect odbcReConnect |
| List ODBC Data Sources | odbcDataSources |
| Request Information on an ODBC Connection | odbcGetInfo |
| ODBC Set Auto-Commit Mode | odbcEndTran odbcSetAutoCommit |
| Specify or Query a Mapping of R Types to DBMS Types | getSqlTypeInfo setSqlTypeInfo |
| Query Column Structure in ODBC Tables | sqlColumns sqlPrimaryKeys |
| ODBC Copy | sqlCopy sqlCopyTable |
| Deletion Operations on Tables in ODBC databases | sqlClear sqlDrop |
| Reading Tables from ODBC Databases | sqlFetch sqlFetchMore |
| Query an ODBC Database | sqlGetResults sqlQuery |
| Write a Data Frame to a Table in an ODBC Database | sqlSave sqlUpdate |
| List Tables on an ODBC Connection | sqlTables |
| Request Information about Data Types in an ODBC Database | sqlTypeInfo |