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'))

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

On CRAN:

3.54 score 23 packages 6 scripts 36 exports 3 dependencies

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

Target	Result	Date
Doc / Vignettes	OK	Nov 01 2024
R-4.5-linux	ERROR	Nov 03 2024
R-4.4-mac	ERROR	Nov 03 2024
R-4.3-mac	ERROR	Nov 03 2024

Exports:.append_con .get_con data2access get_con getSqlTypeInfo odbcClose odbcConnect odbcConnectAccess odbcConnectAccess2007 odbcDataSources odbcDriverConnect odbcEndTran odbcGetErrMsg odbcGetInfo remote_access_query setSqlTypeInfo setSqlTypeInfo2 sqlClear sqlDrop sqlDrop_r2r sqlFetch sqlFetchMore sqlGetResults_r2r sqlQuery sqlQuery_r2r sqlSave sqlSave_r2r sqlTables sqlTables_r2r sqlUpdate sqlUpdate_r2r start_server start_server_access2007 stop_remote_odbc_server_access stop_server write_access_db

Dependencies:pbdZMQ r2r RODBC

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
odbc32: 32-bit ODBC drivers for 64-bit R sessions	odbc32-package odbc32
Append a (new) connection to a global list of connections	.append_con
Closes odbc32 connection	close.odbc32
Connect to Database Via ODBC using RODBC	connect_remotely
Create Object of Class "odbc32"	create_odbc32_object
writing data into MS Access via 32bit R session script	data2access
Default Socket	default_socket
Specify or retrieve a mapping of R types to DBMS datatypes.	getSqlTypeInfo setSqlTypeInfo setSqlTypeInfo2
close odbc32 connection	odbcClose
establish ODBC connection defined by DSN name	odbcConnect
Connect to an Access database (*.mdb)	odbcConnectAccess
Connect to an Access 2007 database	odbcConnectAccess2007
list data sources	odbcDataSources
establish ODBC connection based on a connection string	odbcDriverConnect
clear/empty a db table	odbcEndTran
Get error message	odbcGetErrMsg
Information on an ODBC connection.	odbcGetInfo
Path to File in This Package	package_file
print method for odbc32	print.odbc32
Query over remote connection	remote_access_query
Path to Rscript.exe (on Windows)	rscript_path
clear/empty a db table	sqlClear
drop a db table	sqlDrop
fetch db table	sqlFetch sqlFetchMore
send query to a db and get results	sqlQuery
upload table to a db	sqlSave
list tables in DB	sqlTables
update db table	sqlUpdate
Start a new R session with a running r2r server	start_server
Start r2r server connected to an Access database over 32-bit ODBC driver	start_server_access2007
Stop r2r server running on a remote R session	stop_server
export data from Rdata file into MS Access db via separate 32-bit Rscript	write_access_db