{ "_id": "6a1eabb7b25058d4daad9c0b", "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-06-02 10:06:23 UTC", "User": "root" }, "MD5sum": "b7159df847296fb10d44dcb9bc914a62", "_user": "hsonne", "_type": "src", "_file": "odbc32_0.2.9.9002.tar.gz", "_fileid": "e8d3e99d2953dbf047f2d7b9860b888f32ffa5c4405ad5149b85b62c4ea7bb8b", "_filesize": 132117, "_sha256": "e8d3e99d2953dbf047f2d7b9860b888f32ffa5c4405ad5149b85b62c4ea7bb8b", "_created": "2026-06-02T10:06:23.000Z", "_published": "2026-06-02T10:08:55.257Z", "_distro": "noble", "_jobs": [ { "job": 79047154194, "time": 111, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "7354819716" }, { "job": 79047154073, "time": 108, "config": "linux-release-x86_64", "r": "4.6.0", "check": "ERROR", "artifact": "7354818696" }, { "job": 79047154211, "time": 123, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "7354823489" }, { "job": 79047153992, "time": 113, "config": "macos-release-arm64", "r": "4.6.0", "check": "ERROR", "artifact": "7354820120" }, { "job": 79046649445, "time": 175, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7354782171" }, { "job": 79047153979, "time": 108, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7354818572" }, { "job": 79047154132, "time": 67, "config": "windows-devel", "r": "4.7.0", "check": "ERROR", "artifact": "7354805303" }, { "job": 79047154109, "time": 71, "config": "windows-oldrel", "r": "4.5.3", "check": "ERROR", "artifact": "7354807028" }, { "job": 79047154029, "time": 65, "config": "windows-release", "r": "4.6.0", "check": "ERROR", "artifact": "7354804540" } ], "_buildurl": "https://github.com/r-universe/hsonne/actions/runs/26812712331", "_status": "success", "_host": "GitHub-Actions", "_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 }, "_registered": true, "_dependencies": [ { "package": "r2r", "role": "Imports" }, { "package": "RODBC", "role": "Imports" }, { "package": "testthat", "role": "Suggests" } ], "_owner": "hsonne", "_selfowned": true, "_usedby": 18, "_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" }, "_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.0", "_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.4313637641589874, "_indexed": true, "_nocasepkg": "odbc32", "_universes": [ "hsonne", "vh-d" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.9.9002", "date": "2026-06-02T10:08:20.000Z", "distro": "noble", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "0e657b48d36a9453a19b5dc48bdb6cec2b5d032d1120dd7738bc730be3bf56c2", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/26812712331" }, { "r": "4.6.0", "os": "linux", "version": "0.2.9.9002", "date": "2026-06-02T10:08:17.000Z", "distro": "noble", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "a1518b368d7e256ce10fb206659a5b22226599e991d07f5cae92f44ae48fa33e", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/26812712331" }, { "r": "4.5.3", "os": "mac", "version": "0.2.9.9002", "date": "2026-06-02T10:08:32.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "a5314d88c17175a419e4158379c569a8246c5b3766ae1129d82041b41767bae1", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/26812712331" }, { "r": "4.6.0", "os": "mac", "version": "0.2.9.9002", "date": "2026-06-02T10:08:23.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "c79c909d0739c976e6cc71ae8f73b46f84dcdb525a30606b00d2c860b29ed135", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/26812712331" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.9.9002", "date": "2026-06-02T10:08:26.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "2e60275ce6ab03654f86057a0219c531bacaa64d73c9cb2b571d836954fe1014", "status": "success", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/26812712331" }, { "r": "4.7.0", "os": "win", "version": "0.2.9.9002", "date": "2026-06-02T10:07:32.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "8368a73e01840dc47f0d3359df2309079d8934fc51badf99e82d21df192600e9", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/26812712331" }, { "r": "4.5.3", "os": "win", "version": "0.2.9.9002", "date": "2026-06-02T10:07:37.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "a8d364e730800e290677461b72c2e8840d74dace516516e90a5f0ed2309182b8", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/26812712331" }, { "r": "4.6.0", "os": "win", "version": "0.2.9.9002", "date": "2026-06-02T10:07:29.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "d41880af5cfef012203d6e00cf681e71f92e8b47fadd548c401de369fc7c0d3a", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/hsonne/actions/runs/26812712331" } ] }