Package: odbc32 0.2.9.9002

Vaclav Hausenblas

odbc32: 32-bit ODBC drivers for 64-bit R sessions

Tools for using 32-bit ODBC drivers from 64-bit R sessions. Based on socket connection between 64-bit R and host 32-bit R.

Authors:Vaclav Hausenblas

odbc32_0.2.9.9002.tar.gz
odbc32_0.2.9.9002.zip(r-4.7)odbc32_0.2.9.9002.zip(r-4.6)odbc32_0.2.9.9002.zip(r-4.5)
odbc32_0.2.9.9002.tgz(r-4.6-any)odbc32_0.2.9.9002.tgz(r-4.5-any)
odbc32_0.2.9.9002.tar.gz(r-4.7-any)odbc32_0.2.9.9002.tar.gz(r-4.6-any)
odbc32_0.2.9.9002.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
odbc32/json (API)

# Install 'odbc32' in R:
install.packages('odbc32', repos = c('https://hsonne.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/hsonne/odbc32/issues

On CRAN:

Conda:

3.43 score 18 packages 7 scripts 36 exports 4 dependencies

Last updated from:1ea1dfe70d. Checks:7 ERROR, 2 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64ERROR111
source / vignettesOK175
linux-release-x86_64ERROR108
macos-release-arm64ERROR113
macos-oldrel-arm64ERROR123
windows-develERROR67
windows-releaseERROR65
windows-oldrelERROR71
wasm-releaseOK108

Exports:.append_con.get_condata2accessget_congetSqlTypeInfoodbcCloseodbcConnectodbcConnectAccessodbcConnectAccess2007odbcDataSourcesodbcDriverConnectodbcEndTranodbcGetErrMsgodbcGetInforemote_access_querysetSqlTypeInfosetSqlTypeInfo2sqlClearsqlDropsqlDrop_r2rsqlFetchsqlFetchMoresqlGetResults_r2rsqlQuerysqlQuery_r2rsqlSavesqlSave_r2rsqlTablessqlTables_r2rsqlUpdatesqlUpdate_r2rstart_serverstart_server_access2007stop_remote_odbc_server_accessstop_serverwrite_access_db

Dependencies:digestr2rrlangRODBC

Readme and manuals

Help Manual

Help pageTopics
odbc32: 32-bit ODBC drivers for 64-bit R sessionsodbc32-package odbc32
Append a (new) connection to a global list of connections.append_con
Closes odbc32 connectionclose.odbc32
Connect to Database Via ODBC using RODBCconnect_remotely
Create Object of Class "odbc32"create_odbc32_object
writing data into MS Access via 32bit R session scriptdata2access
Default Socketdefault_socket
Specify or retrieve a mapping of R types to DBMS datatypes.getSqlTypeInfo setSqlTypeInfo setSqlTypeInfo2
close odbc32 connectionodbcClose
establish ODBC connection defined by DSN nameodbcConnect
Connect to an Access database (*.mdb)odbcConnectAccess
Connect to an Access 2007 databaseodbcConnectAccess2007
list data sourcesodbcDataSources
establish ODBC connection based on a connection stringodbcDriverConnect
clear/empty a db tableodbcEndTran
Get error messageodbcGetErrMsg
Information on an ODBC connection.odbcGetInfo
Path to File in This Packagepackage_file
print method for odbc32print.odbc32
Query over remote connectionremote_access_query
Path to Rscript.exe (on Windows)rscript_path
clear/empty a db tablesqlClear
drop a db tablesqlDrop
fetch db tablesqlFetch sqlFetchMore
send query to a db and get resultssqlQuery
upload table to a dbsqlSave
list tables in DBsqlTables
update db tablesqlUpdate
Start a new R session with a running r2r serverstart_server
Start r2r server connected to an Access database over 32-bit ODBC driverstart_server_access2007
Stop r2r server running on a remote R sessionstop_server
export data from Rdata file into MS Access db via separate 32-bit Rscriptwrite_access_db