Package: RODBCDBI 0.1.1
RODBCDBI: Provides Access to Databases Through the ODBC Interface
An implementation of R's DBI interface using ODBC package as a back-end. This allows R to connect to any DBMS that has a ODBC driver.
Authors:
RODBCDBI_0.1.1.tar.gz
RODBCDBI_0.1.1.zip(r-4.5)RODBCDBI_0.1.1.zip(r-4.4)RODBCDBI_0.1.1.zip(r-4.3)
RODBCDBI_0.1.1.tgz(r-4.4-any)RODBCDBI_0.1.1.tgz(r-4.3-any)
RODBCDBI_0.1.1.tar.gz(r-4.5-noble)RODBCDBI_0.1.1.tar.gz(r-4.4-noble)
RODBCDBI_0.1.1.tgz(r-4.4-emscripten)RODBCDBI_0.1.1.tgz(r-4.3-emscripten)
RODBCDBI.pdf |RODBCDBI.html✨
RODBCDBI/json (API)
# Install 'RODBCDBI' in R: |
install.packages('RODBCDBI', repos = c('https://teramonagi.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/teramonagi/rodbcdbi/issues
Last updated 8 years agofrom:915ef7da07. Checks:OK: 3 NOTE: 4. Indexed: yes.
Target | Result | Date |
---|---|---|
Doc / Vignettes | OK | Oct 27 2024 |
R-4.5-win | NOTE | Oct 27 2024 |
R-4.5-linux | NOTE | Oct 27 2024 |
R-4.4-win | NOTE | Oct 27 2024 |
R-4.4-mac | NOTE | Oct 27 2024 |
R-4.3-win | OK | Oct 27 2024 |
R-4.3-mac | OK | Oct 27 2024 |
Exports:dbClearResultdbColumnInfodbConnectdbDisconnectdbExistsTabledbFetchdbGetInfodbGetRowCountdbGetStatementdbHasCompleteddbIsValiddbListFieldsdbListTablesdbReadTabledbRemoveTabledbSendQuerydbUnloadDriverdbWriteTableODBC
Readme and manuals
Help Manual
Help page | Topics |
---|---|
Connect/disconnect to a ODBC data source | dbConnect,ODBCDriver-method |
Close a current session. | dbDisconnect,ODBCConnection-method |
Does the table exist? | dbExistsTable,ODBCConnection,character-method |
Get DBMS metadata. | dbGetInfo,ODBCConnection-method |
List fields in specified table. | dbListFields,ODBCConnection,character-method |
List available ODBC tables. | dbListTables,ODBCConnection-method |
Convenience functions for importing/exporting DBMS tables | dbReadTable,ODBCConnection,character-method |
Remove a table from the database. | dbRemoveTable,ODBCConnection,character-method |
Execute a statement on a given database connection. | dbClearResult,ODBCResult-method dbFetch,ODBCResult-method dbHasCompleted,ODBCResult-method dbSendQuery,ODBCConnection-method |
Write a local data frame or file to the database. | dbWriteTable,ODBCConnection,character,data.frame-method |
Generate an object of ODBCDriver class | ODBC |
Database interface meta-data. | dbColumnInfo,ODBCResult-method dbGetInfo,ODBCResult-method dbGetRowCount,ODBCResult-method dbGetStatement,ODBCResult-method odbc-meta |
RODBCDBI | RODBCDBI-package RODBCDBI |