Package: RODBC 1.3-23

Brian Ripley

RODBC: ODBC Database Access

An ODBC database interface.

Authors:Brian Ripley [aut, cre], Michael Lapsley [aut]

RODBC_1.3-23.tar.gz
RODBC_1.3-23.tar.gz(r-4.5-noble)RODBC_1.3-23.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'))

Peer review:

Uses libs:
  • unixodbc– ODBC Driver Manager library for Unix

This package does not link to any Github/Gitlab/R-forge repository. No issue tracker or development information is available.

9.93 score 10 stars 38 packages 2.9k scripts 26k downloads 16 mentions 31 exports 0 dependencies

Last updated 12 months agofrom:a0e9f0aa24. Checks:OK: 2. Indexed: yes.

TargetResultDate
Doc / VignettesOKNov 03 2024
R-4.5-linux-x86_64OKNov 03 2024

Exports:getSqlTypeInfoodbcClearErrorodbcCloseodbcCloseAllodbcConnectodbcDataSourcesodbcDriverConnectodbcEndTranodbcFetchRowsodbcGetErrMsgodbcGetInfoodbcQueryodbcReConnectodbcSetAutoCommitodbcTablesodbcUpdatesetSqlTypeInfosqlClearsqlColumnssqlCopysqlCopyTablesqlDropsqlFetchsqlFetchMoresqlGetResultssqlPrimaryKeyssqlQuerysqlSavesqlTablessqlTypeInfosqlUpdate

Dependencies:

ODBC Connectivity

Rendered fromRODBC.Rnwusingutils::Sweaveon Nov 03 2024.

Last update: 2021-08-30
Started: 2012-03-09

Readme and manuals

Help Manual

Help pageTopics
ODBC Database ConnectivityRODBC-package RODBC
Low-level ODBC functionsodbcClearError odbcFetchRows odbcGetErrMsg odbcQuery odbcTables
ODBC Close Connectionsclose.RODBC odbcClose odbcCloseAll
ODBC Open ConnectionsodbcConnect odbcDriverConnect odbcReConnect
List ODBC Data SourcesodbcDataSources
Request Information on an ODBC ConnectionodbcGetInfo
ODBC Set Auto-Commit ModeodbcEndTran odbcSetAutoCommit
Specify or Query a Mapping of R Types to DBMS TypesgetSqlTypeInfo setSqlTypeInfo
Query Column Structure in ODBC TablessqlColumns sqlPrimaryKeys
ODBC CopysqlCopy sqlCopyTable
Deletion Operations on Tables in ODBC databasessqlClear sqlDrop
Reading Tables from ODBC DatabasessqlFetch sqlFetchMore
Query an ODBC DatabasesqlGetResults sqlQuery
Write a Data Frame to a Table in an ODBC DatabasesqlSave sqlUpdate
List Tables on an ODBC ConnectionsqlTables
Request Information about Data Types in an ODBC DatabasesqlTypeInfo