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 12 days agofrom:e1a6307002. Checks:OK: 2. Indexed: yes.
Target | Result | Date |
---|---|---|
Doc / Vignettes | OK | Dec 12 2024 |
R-4.5-linux-x86_64 | OK | Dec 12 2024 |
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 |