{ "_id": "6a478fdb8b9f0d9747cf12f0", "Package": "odbc32", "Type": "Package", "Title": "32-bit ODBC drivers for 64-bit R sessions", "Version": "0.2.9.9002", "Author": "Vaclav Hausenblas", "Maintainer": "Vaclav Hausenblas ", "Description": "Tools for using 32-bit ODBC drivers from 64-bit R\nsessions. Based on socket connection between 64-bit R and host\n32-bit R.", "License": "MIT", "Encoding": "UTF-8", "RoxygenNote": "7.0.2", "Remotes": [ "github::vh-d/r2r" ], "Config/pak/sysreqs": "unixodbc-dev libzmq3-dev", "Repository": "https://hsonne.r-universe.dev", "Date/Publication": "2019-12-14 12:06:59 UTC", "RemoteUrl": "https://github.com/hsonne/odbc32", "RemoteRef": "HEAD", "RemoteSha": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-02 08:34:25 UTC", "User": "root" }, "_user": "hsonne", "_type": "src", "_file": "odbc32_0.2.9.9002.tar.gz", "_fileid": "https://r2.ropensci.org/44dc7e5d3cfd59c09d08314e5df457fdfbf91dea810cc8cef4b1ccda12c0b126", "_filesize": 132942, "_sha256": "44dc7e5d3cfd59c09d08314e5df457fdfbf91dea810cc8cef4b1ccda12c0b126", "_expires": "2026-10-11T10:32:59.000Z", "_created": "2026-07-02T08:34:25.000Z", "_published": "2026-07-03T10:32:59.536Z", "_jobs": [ { "job": 84981429734, "time": 115, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "8033269808" }, { "job": 84981429318, "time": 113, "config": "linux-release-x86_64", "r": "4.6.1", "check": "ERROR", "artifact": "8033268958" }, { "job": 84981429507, "time": 99, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "8033263878" }, { "job": 84981429242, "time": 88, "config": "macos-release-arm64", "r": "4.6.1", "check": "ERROR", "artifact": "8033259405" }, { "job": 84981429058, "time": 190, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8033224813" }, { "job": 84981429452, "time": 101, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8033264502" }, { "job": 84981429449, "time": 78, "config": "windows-devel", "r": "4.7.0", "check": "ERROR", "artifact": "8033256081" }, { "job": 84981429519, "time": 96, "config": "windows-oldrel", "r": "4.5.3", "check": "ERROR", "artifact": "8033264959" }, { "job": 84981429344, "time": 59, "config": "windows-release", "r": "4.6.1", "check": "ERROR", "artifact": "8033249044" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/hsonne/actions/runs/28576493605", "_status": "success", "_upstream": "https://github.com/hsonne/odbc32", "_commit": { "id": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "author": "Vaclav Hausenblas ", "committer": "Vaclav Hausenblas ", "message": "Allow repeating tests without reverting accdb file.\n", "time": 1576325219 }, "_maintainer": { "name": "Vaclav Hausenblas", "email": "vaclav.hausenblas@gmail.com", "login": "vh-d", "description": "", "uuid": 8167061 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "r2r", "role": "Imports" }, { "package": "RODBC", "role": "Imports" }, { "package": "testthat", "role": "Suggests" } ], "_owner": "hsonne", "_selfowned": true, "_usedby": 20, "_updates": [], "_tags": [], "_stars": 0, "_contributors": [ { "user": "vh-d", "count": 52, "uuid": 8167061 }, { "user": "hsonne", "count": 28, "uuid": 11964315 } ], "_userbio": { "uuid": 11964315, "type": "user", "name": "Hauke Sonnenberg", "followers": 17 }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/odbc32" }, "_devurl": "https://github.com/hsonne/odbc32", "_searchresults": 7, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/odbc32.html", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_cranurl": false, "_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" ], "_help": [ { "page": "odbc32-package", "title": "odbc32: 32-bit ODBC drivers for 64-bit R sessions", "topics": [ "odbc32-package", "odbc32" ] }, { "page": "dot-append_con", "title": "Append a (new) connection to a global list of connections", "topics": [ ".append_con" ] }, { "page": "close.odbc32", "title": "Closes odbc32 connection", "topics": [ "close.odbc32" ] }, { "page": "connect_remotely", "title": "Connect to Database Via ODBC using RODBC", "topics": [ "connect_remotely" ] }, { "page": "create_odbc32_object", "title": "Create Object of Class \"odbc32\"", "topics": [ "create_odbc32_object" ] }, { "page": "data2access", "title": "writing data into MS Access via 32bit R session script", "topics": [ "data2access" ] }, { "page": "default_socket", "title": "Default Socket", "topics": [ "default_socket" ] }, { "page": "setSqlTypeInfo", "title": "Specify or retrieve a mapping of R types to DBMS datatypes.", "topics": [ "getSqlTypeInfo", "setSqlTypeInfo", "setSqlTypeInfo2" ] }, { "page": "odbcClose", "title": "close odbc32 connection", "topics": [ "odbcClose" ] }, { "page": "odbcConnect", "title": "establish ODBC connection defined by DSN name", "topics": [ "odbcConnect" ] }, { "page": "odbcConnectAccess", "title": "Connect to an Access database (*.mdb)", "topics": [ "odbcConnectAccess" ] }, { "page": "odbcConnectAccess2007", "title": "Connect to an Access 2007 database", "topics": [ "odbcConnectAccess2007" ] }, { "page": "odbcDataSources", "title": "list data sources", "topics": [ "odbcDataSources" ] }, { "page": "odbcDriverConnect", "title": "establish ODBC connection based on a connection string", "topics": [ "odbcDriverConnect" ] }, { "page": "odbcEndTran", "title": "clear/empty a db table", "topics": [ "odbcEndTran" ] }, { "page": "odbcGetErrMsg", "title": "Get error message", "topics": [ "odbcGetErrMsg" ] }, { "page": "odbcGetInfo", "title": "Information on an ODBC connection.", "topics": [ "odbcGetInfo" ] }, { "page": "package_file", "title": "Path to File in This Package", "topics": [ "package_file" ] }, { "page": "print.odbc32", "title": "print method for odbc32", "topics": [ "print.odbc32" ] }, { "page": "remote_access_query", "title": "Query over remote connection", "topics": [ "remote_access_query" ] }, { "page": "rscript_path", "title": "Path to Rscript.exe (on Windows)", "topics": [ "rscript_path" ] }, { "page": "sqlClear", "title": "clear/empty a db table", "topics": [ "sqlClear" ] }, { "page": "sqlDrop", "title": "drop a db table", "topics": [ "sqlDrop" ] }, { "page": "sqlFetch", "title": "fetch db table", "topics": [ "sqlFetch", "sqlFetchMore" ] }, { "page": "sqlQuery", "title": "send query to a db and get results", "topics": [ "sqlQuery" ] }, { "page": "sqlSave", "title": "upload table to a db", "topics": [ "sqlSave" ] }, { "page": "sqlTables", "title": "list tables in DB", "topics": [ "sqlTables" ] }, { "page": "sqlUpdate", "title": "update db table", "topics": [ "sqlUpdate" ] }, { "page": "connect", "title": "Start a new R session with a running r2r server", "topics": [ "start_server" ] }, { "page": "start_server_access2007", "title": "Start r2r server connected to an Access database over 32-bit ODBC driver", "topics": [ "start_server_access2007" ] }, { "page": "stop_server", "title": "Stop r2r server running on a remote R session", "topics": [ "stop_server" ] }, { "page": "write_access_db", "title": "export data from Rdata file into MS Access db via separate 32-bit Rscript", "topics": [ "write_access_db" ] } ], "_readme": "https://github.com/hsonne/odbc32/raw/HEAD/README.md", "_rundeps": [ "digest", "r2r", "rlang", "RODBC" ], "_score": 3.4771212547196626, "_indexed": true, "_nocasepkg": "odbc32", "_universes": [ "hsonne", "vh-d" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.9.9002", "date": "2026-07-02T08:36:29.000Z", "distro": "resolute", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "https://r2.ropensci.org/0e69fa974ca6bb73042c24ade97c7dcac2973406bdcfd61e58f49e6a58004dd1", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/28576493605" }, { "r": "4.6.1", "os": "linux", "version": "0.2.9.9002", "date": "2026-07-02T08:36:26.000Z", "distro": "resolute", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "https://r2.ropensci.org/6986919f118eb57025dd36da8cc0756c0525be46a0f19cdb2056d34111dd1ba2", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/28576493605" }, { "r": "4.5.3", "os": "mac", "version": "0.2.9.9002", "date": "2026-07-02T08:36:12.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "https://r2.ropensci.org/f2f03a314a1b29e2e55f753311e4cee408afdec3a2b3f48b05fbaae6fdbc8eb3", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/28576493605" }, { "r": "4.6.1", "os": "mac", "version": "0.2.9.9002", "date": "2026-07-02T08:36:01.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "https://r2.ropensci.org/e67e4aa91da73e805df50ac7c04830dedce56a1da10ecbb033824addf64cc0bd", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/28576493605" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.9.9002", "date": "2026-07-02T08:36:23.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "https://r2.ropensci.org/d38b6bc3e29ffd406e7110be8b42be3b242c1424f67242e11f86f81b378d295e", "status": "success", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/28576493605" }, { "r": "4.7.0", "os": "win", "version": "0.2.9.9002", "date": "2026-07-02T08:35:47.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "https://r2.ropensci.org/b2ac5810bc346b336a443264f138f99ce21e5a56fa370e5cba0ca88e650ae211", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/28576493605" }, { "r": "4.5.3", "os": "win", "version": "0.2.9.9002", "date": "2026-07-02T08:36:07.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "https://r2.ropensci.org/32132b4a8b1c236b5edd5fc1e3461b94a1268f83f698cf3d43102164d1b011d4", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/28576493605" }, { "r": "4.6.1", "os": "win", "version": "0.2.9.9002", "date": "2026-07-02T08:35:28.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "https://r2.ropensci.org/1abf6a9bd1e038351e8ed5a2b49d84a1146cf650264f8f82ae449152fca3917d", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/28576493605" } ] }