{
  "_id": "6ad0b6acb0a1b4b4099d73b7",
  "Package": "RODBC",
  "Version": "1.3-26.3",
  "Revision": "$Rev: 3715 $",
  "Date": "2026-09-15",
  "Authors@R": "c(person(\"Brian\", \"Ripley\", role = c(\"aut\", \"cre\"),\nemail = \"Brian.Ripley@R-project.org\"),\nperson(\"Michael\", \"Lapsley\", role = \"aut\",\ncomment = \"1999 to Oct 2002\"))",
  "Title": "ODBC Database Access",
  "Description": "An ODBC database interface.",
  "SystemRequirements": "An ODBC3 driver manager and drivers.",
  "LazyLoad": "yes",
  "Biarch": "yes",
  "License": "GPL-2 | GPL-3",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-10-15 11:14:50 UTC",
    "User": "root"
  },
  "Author": "Brian Ripley [aut, cre], Michael Lapsley [aut] (1999 to Oct\n2002)",
  "Maintainer": "Brian Ripley <Brian.Ripley@R-project.org>",
  "Config/pak/sysreqs": "unixodbc-dev",
  "Repository": "https://cran.r-universe.dev",
  "Date/Publication": "2026-09-15 15:46:02 UTC",
  "RemoteUrl": "https://github.com/cran/RODBC",
  "RemoteRef": "HEAD",
  "RemoteSha": "44effc84dcabe4e4b17c8e57d68957067d1b2706",
  "_user": "cran",
  "_type": "src",
  "_file": "RODBC_1.3-26.3.tar.gz",
  "_fileid": "https://r2.ropensci.org/628b6700359048d4b48737ead7792d22533723418e796f5c4bcebe0dfff36e88",
  "_filesize": 1206972,
  "_sha256": "628b6700359048d4b48737ead7792d22533723418e796f5c4bcebe0dfff36e88",
  "_expires": "2027-01-23T11:19:05.000Z",
  "_created": "2026-10-15T11:14:50.000Z",
  "_published": "2026-10-15T11:19:07.967Z",
  "_buildurl": "https://github.com/r-universe/cran/actions/runs/38725657697",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 116391922365,
      "time": 89,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11967233805"
    },
    {
      "job": 116391922226,
      "time": 109,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11967353626"
    },
    {
      "job": 116391922219,
      "time": 98,
      "config": "linux-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11968497424"
    },
    {
      "job": 116391922220,
      "time": 139,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11968377543"
    },
    {
      "job": 116390886398,
      "time": 154,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11967772469"
    },
    {
      "job": 116391922222,
      "time": 70,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "FAIL",
      "artifact": ""
    },
    {
      "job": 116391922261,
      "time": 202,
      "config": "windows-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11968447679"
    },
    {
      "job": 116391922180,
      "time": 123,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11968507522"
    },
    {
      "job": 116391922213,
      "time": 217,
      "config": "windows-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11968252930"
    },
    {
      "job": 116391922102,
      "time": 94,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11968067550"
    }
  ],
  "_upstream": "https://github.com/cran/RODBC",
  "_commit": {
    "id": "44effc84dcabe4e4b17c8e57d68957067d1b2706",
    "author": "Brian Ripley <Brian.Ripley@R-project.org>",
    "committer": "cran-robot <csardi.gabor+cran@gmail.com>",
    "message": "version 1.3-26.3\n",
    "time": 1789487162
  },
  "_maintainer": {
    "name": "Brian Ripley",
    "email": "brian.ripley@r-project.org"
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.0.0",
      "role": "Depends"
    },
    {
      "package": "stats",
      "role": "Imports"
    },
    {
      "package": "MASS",
      "role": "Suggests"
    }
  ],
  "_owner": "cran",
  "_selfowned": false,
  "_usedby": 36,
  "_updates": [
    {
      "week": "2025-51",
      "n": 1
    },
    {
      "week": "2026-33",
      "n": 1
    },
    {
      "week": "2026-38",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "1.3-26.1",
      "date": "2025-12-15"
    },
    {
      "name": "1.3-26.2",
      "date": "2026-08-11"
    },
    {
      "name": "1.3-26.3",
      "date": "2026-09-15"
    }
  ],
  "_stars": 10,
  "_userbio": {
    "uuid": 6899542,
    "type": "organization",
    "name": "cran",
    "followers": 630,
    "description": "Unofficial read-only mirror of all CRAN R packages"
  },
  "_downloads": {
    "count": 20187,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RODBC"
  },
  "_mentions": 16,
  "_searchresults": 4544,
  "_topics": [
    "unixodbc"
  ],
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/RODBC.html"
  ],
  "_realowner": "cran",
  "_cranurl": false,
  "_releases": [
    {
      "version": "0.7-2",
      "date": "2000-05-24"
    },
    {
      "version": "0.8-2",
      "date": "2000-12-06"
    },
    {
      "version": "0.8-3",
      "date": "2001-06-22"
    },
    {
      "version": "0.9-1",
      "date": "2002-10-30"
    },
    {
      "version": "1.0-1",
      "date": "2003-01-22"
    },
    {
      "version": "1.0-2",
      "date": "2003-05-14"
    },
    {
      "version": "1.0-3",
      "date": "2003-05-25"
    },
    {
      "version": "1.0-4",
      "date": "2003-07-19"
    },
    {
      "version": "1.1-1",
      "date": "2004-09-15"
    },
    {
      "version": "1.1-2",
      "date": "2004-10-27"
    },
    {
      "version": "1.1-3",
      "date": "2005-02-07"
    },
    {
      "version": "1.1-4",
      "date": "2005-08-05"
    },
    {
      "version": "1.1-5",
      "date": "2006-01-10"
    },
    {
      "version": "1.1-6",
      "date": "2006-04-05"
    },
    {
      "version": "1.1-7",
      "date": "2006-05-29"
    },
    {
      "version": "1.1-8",
      "date": "2007-01-09"
    },
    {
      "version": "1.1-9",
      "date": "2007-04-04"
    },
    {
      "version": "1.2-0",
      "date": "2007-04-24"
    },
    {
      "version": "1.2-1",
      "date": "2007-06-04"
    },
    {
      "version": "1.2-2",
      "date": "2007-10-20"
    },
    {
      "version": "1.2-3",
      "date": "2008-01-27"
    },
    {
      "version": "1.2-4",
      "date": "2008-11-19"
    },
    {
      "version": "1.2-5",
      "date": "2009-01-21"
    },
    {
      "version": "1.2-6",
      "date": "2009-06-23"
    },
    {
      "version": "1.3-0",
      "date": "2009-07-28"
    },
    {
      "version": "1.3-1",
      "date": "2009-10-12"
    },
    {
      "version": "1.3-2",
      "date": "2010-07-26"
    },
    {
      "version": "1.3-3",
      "date": "2011-07-26"
    },
    {
      "version": "1.3-4",
      "date": "2012-01-31"
    },
    {
      "version": "1.3-5",
      "date": "2012-03-09"
    },
    {
      "version": "1.3-6",
      "date": "2013-06-28"
    },
    {
      "version": "1.3-7",
      "date": "2013-07-01"
    },
    {
      "version": "1.3-8",
      "date": "2013-09-03"
    },
    {
      "version": "1.3-9",
      "date": "2013-11-01"
    },
    {
      "version": "1.3-10",
      "date": "2013-11-25"
    },
    {
      "version": "1.3-11",
      "date": "2015-02-26"
    },
    {
      "version": "1.3-12",
      "date": "2015-06-29"
    },
    {
      "version": "1.3-13",
      "date": "2016-04-14"
    },
    {
      "version": "1.3-14",
      "date": "2016-09-26"
    },
    {
      "version": "1.3-15",
      "date": "2017-04-13"
    },
    {
      "version": "1.3-16",
      "date": "2019-09-03"
    },
    {
      "version": "1.3-17",
      "date": "2020-05-11"
    },
    {
      "version": "1.3-18",
      "date": "2021-08-30"
    },
    {
      "version": "1.3-19",
      "date": "2021-09-16"
    },
    {
      "version": "1.3-20",
      "date": "2022-12-06"
    },
    {
      "version": "1.3-21",
      "date": "2023-08-19"
    },
    {
      "version": "1.3-22",
      "date": "2023-11-21"
    },
    {
      "version": "1.3-23",
      "date": "2023-11-25"
    },
    {
      "version": "1.3-25",
      "date": "2024-12-11"
    },
    {
      "version": "1.3-25.1",
      "date": "2024-12-11"
    },
    {
      "version": "1.3-26",
      "date": "2024-12-12"
    },
    {
      "version": "1.3-26.1",
      "date": "2025-12-15"
    },
    {
      "version": "1.3-26.2",
      "date": "2026-08-11"
    },
    {
      "version": "1.3-26.3",
      "date": "2026-09-15"
    }
  ],
  "_exports": [
    "getSqlTypeInfo",
    "odbcClearError",
    "odbcClose",
    "odbcCloseAll",
    "odbcConnect",
    "odbcDataSources",
    "odbcDriverConnect",
    "odbcEndTran",
    "odbcFetchRows",
    "odbcGetErrMsg",
    "odbcGetInfo",
    "odbcQuery",
    "odbcReConnect",
    "odbcSetAutoCommit",
    "odbcTables",
    "odbcUpdate",
    "setSqlTypeInfo",
    "sqlClear",
    "sqlColumns",
    "sqlCopy",
    "sqlCopyTable",
    "sqlDrop",
    "sqlFetch",
    "sqlFetchMore",
    "sqlGetResults",
    "sqlPrimaryKeys",
    "sqlQuery",
    "sqlSave",
    "sqlTables",
    "sqlTypeInfo",
    "sqlUpdate"
  ],
  "_help": [
    {
      "page": "RODBC-package",
      "title": "ODBC Database Connectivity",
      "topics": [
        "RODBC-package",
        "RODBC"
      ]
    },
    {
      "page": "odbc",
      "title": "Low-level ODBC functions",
      "topics": [
        "odbcClearError",
        "odbcFetchRows",
        "odbcGetErrMsg",
        "odbcQuery",
        "odbcTables"
      ]
    },
    {
      "page": "odbcClose",
      "title": "ODBC Close Connections",
      "topics": [
        "close.RODBC",
        "odbcClose",
        "odbcCloseAll"
      ]
    },
    {
      "page": "odbcConnect",
      "title": "ODBC Open Connections",
      "topics": [
        "odbcConnect",
        "odbcDriverConnect",
        "odbcReConnect"
      ]
    },
    {
      "page": "odbcDataSources",
      "title": "List ODBC Data Sources",
      "topics": [
        "odbcDataSources"
      ]
    },
    {
      "page": "odbcGetInfo",
      "title": "Request Information on an ODBC Connection",
      "topics": [
        "odbcGetInfo"
      ]
    },
    {
      "page": "odbcSetAutoCommit",
      "title": "ODBC Set Auto-Commit Mode",
      "topics": [
        "odbcEndTran",
        "odbcSetAutoCommit"
      ]
    },
    {
      "page": "setSqlTypeInfo",
      "title": "Specify or Query a Mapping of R Types to DBMS Types",
      "topics": [
        "getSqlTypeInfo",
        "setSqlTypeInfo"
      ]
    },
    {
      "page": "sqlColumns",
      "title": "Query Column Structure in ODBC Tables",
      "topics": [
        "sqlColumns",
        "sqlPrimaryKeys"
      ]
    },
    {
      "page": "sqlCopy",
      "title": "ODBC Copy",
      "topics": [
        "sqlCopy",
        "sqlCopyTable"
      ]
    },
    {
      "page": "sqlDrop",
      "title": "Deletion Operations on Tables in ODBC databases",
      "topics": [
        "sqlClear",
        "sqlDrop"
      ]
    },
    {
      "page": "sqlFetch",
      "title": "Reading Tables from ODBC Databases",
      "topics": [
        "sqlFetch",
        "sqlFetchMore"
      ]
    },
    {
      "page": "sqlQuery",
      "title": "Query an ODBC Database",
      "topics": [
        "sqlGetResults",
        "sqlQuery"
      ]
    },
    {
      "page": "sqlSave",
      "title": "Write a Data Frame to a Table in an ODBC Database",
      "topics": [
        "sqlSave",
        "sqlUpdate"
      ]
    },
    {
      "page": "sqlTables",
      "title": "List Tables on an ODBC Connection",
      "topics": [
        "sqlTables"
      ]
    },
    {
      "page": "sqlTypeInfo",
      "title": "Request Information about Data Types in an ODBC Database",
      "topics": [
        "sqlTypeInfo"
      ]
    }
  ],
  "_rundeps": [],
  "_sysdeps": [
    {
      "shlib": "libodbc",
      "package": "libodbc2",
      "headers": "unixodbc-dev",
      "source": "unixodbc",
      "version": "2.3.14-1",
      "name": "unixodbc",
      "homepage": "https://www.unixodbc.org",
      "description": "ODBC Driver Manager library for Unix"
    }
  ],
  "_vignettes": [
    {
      "source": "RODBC.Rnw",
      "filename": "RODBC.pdf",
      "title": "ODBC Connectivity",
      "engine": "utils::Sweave",
      "headings": [
        "ODBC Concepts",
        "Basic Usage",
        "Writing to a Database",
        "Data types",
        "Schemas and Catalogs",
        "Internationalization Issues",
        "Excel Drivers",
        "DBMS-specific tidbits",
        "Installation",
        "Specifying DSNs",
        "Internals"
      ],
      "created": "2012-03-09",
      "modified": "2026-09-15 15:46:02",
      "commits": 9
    }
  ],
  "_score": 10.473055115931867,
  "_indexed": true,
  "_nocasepkg": "rodbc",
  "_universes": [
    "cran"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.3-26.3",
      "date": "2026-10-15T11:16:31.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "44effc84dcabe4e4b17c8e57d68957067d1b2706",
      "fileid": "https://r2.ropensci.org/e9117e33faa959c4704fa4d003c7e65ad28d58f0e2e4bc9d9a2a6e354c705f58",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/38725657697"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.3-26.3",
      "date": "2026-10-15T11:16:49.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "44effc84dcabe4e4b17c8e57d68957067d1b2706",
      "fileid": "https://r2.ropensci.org/d70eafa6aef75d8a400332dc3a34d1d87c508875a23d30b9ebc106d5e0d1dc80",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/38725657697"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.3-26.3",
      "date": "2026-10-15T11:16:38.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "44effc84dcabe4e4b17c8e57d68957067d1b2706",
      "fileid": "https://r2.ropensci.org/b65f77274f29347420bd725b7d554ae16eb668753c3a74cad2edd36f18b21534",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/38725657697"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.3-26.3",
      "date": "2026-10-15T11:17:15.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "44effc84dcabe4e4b17c8e57d68957067d1b2706",
      "fileid": "https://r2.ropensci.org/f97473c5068c8229bd6466e41bea168ee396c5d4e392c24f04cbac314a070380",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/38725657697"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.3-26.3",
      "date": "2026-10-15T11:18:10.000Z",
      "arch": "aarch64",
      "commit": "44effc84dcabe4e4b17c8e57d68957067d1b2706",
      "fileid": "https://r2.ropensci.org/b02cec77256f5d654c47ed0d4dd1420986a5dc94385cd70a0b75d68eb6524e02",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/38725657697"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.3-26.3",
      "date": "2026-10-15T11:16:09.000Z",
      "arch": "x86_64",
      "commit": "44effc84dcabe4e4b17c8e57d68957067d1b2706",
      "fileid": "https://r2.ropensci.org/b1d9e8fcfff2fbbb273da4d02476253fd3a0e4ca039a1806453722be0d7c3a0c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/38725657697"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.3-26.3",
      "date": "2026-10-15T11:18:24.000Z",
      "arch": "aarch64",
      "commit": "44effc84dcabe4e4b17c8e57d68957067d1b2706",
      "fileid": "https://r2.ropensci.org/4bcb6b8c68e47da70c4281fb5c95810036e04fd595e9b6882cb9329ca5a8cb58",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/38725657697"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.3-26.3",
      "date": "2026-10-15T11:16:15.000Z",
      "arch": "x86_64",
      "commit": "44effc84dcabe4e4b17c8e57d68957067d1b2706",
      "fileid": "https://r2.ropensci.org/82329f8f998b7e65c81d57bc2a5d5bf624f8f988b2f26d90cf541cf37f871fa0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/38725657697"
    }
  ]
}