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.tgz(r-4.4-any)odbc32_0.2.9.9002.tgz(r-4.3-any)
odbc32_0.2.9.9002.tar.gz(r-4.5-noble)odbc32_0.2.9.9002.tar.gz(r-4.4-noble)
odbc32_0.2.9.9002.tgz(r-4.4-emscripten)odbc32_0.2.9.9002.tgz(r-4.3-emscripten)
odbc32.pdf |odbc32.html
odbc32/json (API)

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

Peer review:

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

On CRAN:

36 exports 3.43 score 3 dependencies 23 dependents 6 scripts

Last updated 5 years agofrom:1ea1dfe70d. Checks:OK: 1 ERROR: 3. Indexed: yes.

TargetResultDate
Doc / VignettesOKSep 02 2024
R-4.5-linuxERRORSep 04 2024
R-4.4-macERRORSep 04 2024
R-4.3-macERRORSep 04 2024

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:pbdZMQr2rRODBC

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