{ "_id": "6a3beb3ac2c86aa1dcf0f239", "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://kwb-r.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-24 14:33:12 UTC", "User": "root" }, "MD5sum": "8c77ae7694ee1bc210847a2625b59627", "_user": "kwb-r", "_type": "src", "_file": "odbc32_0.2.9.9002.tar.gz", "_fileid": "4c63b23727581aedcf6bdc454a275c89cb2b6bafb0db251b4b31a5090d267d3c", "_filesize": 133028, "_sha256": "4c63b23727581aedcf6bdc454a275c89cb2b6bafb0db251b4b31a5090d267d3c", "_created": "2026-06-24T14:33:12.000Z", "_published": "2026-06-24T14:35:38.967Z", "_distro": "resolute", "_jobs": [ { "job": 83221064085, "time": 113, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "7852807237" }, { "job": 83221064110, "time": 110, "config": "linux-release-x86_64", "r": "4.6.0", "check": "ERROR", "artifact": "7852806141" }, { "job": 83221064065, "time": 100, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "7852802428" }, { "job": 83221064073, "time": 85, "config": "macos-release-arm64", "r": "4.6.0", "check": "ERROR", "artifact": "7852793555" }, { "job": 83220088358, "time": 244, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7852752526" }, { "job": 83221064051, "time": 112, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7852807697" }, { "job": 83221064079, "time": 64, "config": "windows-devel", "r": "4.7.0", "check": "ERROR", "artifact": "7852784260" }, { "job": 83221064162, "time": 65, "config": "windows-oldrel", "r": "4.5.3", "check": "ERROR", "artifact": "7852785050" }, { "job": 83221064098, "time": 94, "config": "windows-release", "r": "4.6.0", "check": "ERROR", "artifact": "7852797772" } ], "_buildurl": "https://github.com/r-universe/kwb-r/actions/runs/28105913826", "_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": false, "_usedby": 18, "_updates": [], "_tags": [], "_stars": 0, "_contributors": [ { "user": "vh-d", "count": 52, "uuid": 8167061 }, { "user": "hsonne", "count": 28, "uuid": 11964315 } ], "_userbio": { "uuid": 11964354, "type": "organization", "name": "Kompetenzzentrum Wasser Berlin gGmbH (KWB)", "followers": 23, "description": "KWB is an international centre for water research and knowledge transfer" }, "_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": false, "_nocasepkg": "odbc32", "_universes": [ "kwb-r" ], "_indexurl": "https://hsonne.r-universe.dev/odbc32", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.9.9002", "date": "2026-06-24T14:35:11.000Z", "distro": "resolute", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "0edd268524e735ce7e434476f9e578dd43b26f38c10823d5b2e3f2fec9084eb7", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/kwb-r/actions/runs/28105913826" }, { "r": "4.6.0", "os": "linux", "version": "0.2.9.9002", "date": "2026-06-24T14:35:10.000Z", "distro": "resolute", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "eee270630368b8a4e94de71c93a83dc12ccd52affd0db674d25ab3dcee883876", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/kwb-r/actions/runs/28105913826" }, { "r": "4.5.3", "os": "mac", "version": "0.2.9.9002", "date": "2026-06-24T14:35:02.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "157c4186c899c51670dc21fdd5268717f2be033966bc8946584ab982d00a0617", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/kwb-r/actions/runs/28105913826" }, { "r": "4.6.0", "os": "mac", "version": "0.2.9.9002", "date": "2026-06-24T14:34:45.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "1e76d5027c8f6092728370e27d13aa234f5d141d6bdfbb0f9c965fc6e0996930", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/kwb-r/actions/runs/28105913826" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.9.9002", "date": "2026-06-24T14:35:21.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "ee052b445522908ee7537a333f8b63e3a81a78d696a036ab36e6a99a2d853a91", "status": "success", "buildurl": "https://github.com/r-universe/kwb-r/actions/runs/28105913826" }, { "r": "4.7.0", "os": "win", "version": "0.2.9.9002", "date": "2026-06-24T14:34:18.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "39ed206e19dbb0a2c09f07106e0c3408520663658f9a2fd3fa63f945ef096ba9", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/kwb-r/actions/runs/28105913826" }, { "r": "4.5.3", "os": "win", "version": "0.2.9.9002", "date": "2026-06-24T14:34:18.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "8711593e8f108b59fded42352cc40d62efdbd25730f467e72b50ce97bccd4097", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/kwb-r/actions/runs/28105913826" }, { "r": "4.6.0", "os": "win", "version": "0.2.9.9002", "date": "2026-06-24T14:34:43.000Z", "commit": "1ea1dfe70df6a31a162616ae54ef915e33e60894", "fileid": "ce32ba83ae1601634382d3823bb8a15ac3197a9d2c339209a9aa0ab43f3f3e90", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/kwb-r/actions/runs/28105913826" } ] }