{
  "_id": "6a1f3147b401979e73427b0d",
  "Package": "RODBC",
  "Version": "1.3-26.1",
  "Revision": "$Rev: 3689 $",
  "Date": "2025-12-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-05-15 07:50:47 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": "2025-12-15 12:32:58 UTC",
  "RemoteUrl": "https://github.com/cran/RODBC",
  "RemoteRef": "HEAD",
  "RemoteSha": "9bfdad748a2958c02aff9d8db699066c1188c71a",
  "MD5sum": "7d237593bba2b2e44c307f740577a5f1",
  "_user": "cran",
  "_type": "src",
  "_file": "RODBC_1.3-26.1.tar.gz",
  "_fileid": "08c0024cf5a80fe316150734f824f0bf245893d3a9e641eaceb6019f0d73a6fa",
  "_filesize": 1206821,
  "_sha256": "08c0024cf5a80fe316150734f824f0bf245893d3a9e641eaceb6019f0d73a6fa",
  "_created": "2026-05-15T07:50:47.000Z",
  "_published": "2026-06-02T19:38:47.889Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 79156526065,
      "time": 114,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "7012864615"
    },
    {
      "job": 79156526095,
      "time": 113,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "7012864585"
    },
    {
      "job": 79156526271,
      "time": 136,
      "config": "linux-release-arm64",
      "r": "4.6.0",
      "check": "NOTE",
      "artifact": "7012868284"
    },
    {
      "job": 79156526529,
      "time": 118,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "NOTE",
      "artifact": "7012865204"
    },
    {
      "job": 79156525595,
      "time": 1356,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": ""
    },
    {
      "job": 79156525219,
      "time": 89,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "FAIL",
      "artifact": ""
    }
  ],
  "_buildurl": "https://github.com/r-universe/cran/actions/runs/25906779722",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/cran/RODBC",
  "_commit": {
    "id": "9bfdad748a2958c02aff9d8db699066c1188c71a",
    "author": "Brian Ripley <Brian.Ripley@R-project.org>",
    "committer": "cran-robot <csardi.gabor+cran@gmail.com>",
    "message": "version 1.3-26.1\n",
    "time": 1765801978
  },
  "_maintainer": {
    "name": "Brian Ripley",
    "email": "brian.ripley@r-project.org"
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.0.0",
      "role": "Depends"
    },
    {
      "package": "stats",
      "role": "Imports"
    }
  ],
  "_owner": "cran",
  "_selfowned": false,
  "_usedby": 32,
  "_updates": [
    {
      "week": "2025-51",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "1.3-26.1",
      "date": "2025-12-15"
    }
  ],
  "_stars": 10,
  "_userbio": {
    "uuid": 6899542,
    "type": "organization",
    "name": "cran",
    "description": "Unofficial read-only mirror of all CRAN R packages"
  },
  "_downloads": {
    "count": 16408,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RODBC"
  },
  "_mentions": 16,
  "_searchresults": 3504,
  "_topics": [
    "unixodbc"
  ],
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/RODBC.html",
    "manual.pdf"
  ],
  "_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"
    }
  ],
  "_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.12-1ubuntu0.24.04.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": [],
      "created": "2012-03-09",
      "modified": "2025-12-15 12:32:58",
      "commits": 8
    }
  ],
  "_score": 9.74189097789592,
  "_indexed": true,
  "_nocasepkg": "rodbc",
  "_universes": [
    "cran"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.3-26.1",
      "date": "2026-05-15T08:12:56.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "9bfdad748a2958c02aff9d8db699066c1188c71a",
      "fileid": "6385931c307b8309bd3eee461f15d71a4128fcb56a94877852efcc1c816beec7",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/25906779722"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.3-26.1",
      "date": "2026-05-15T08:12:54.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "9bfdad748a2958c02aff9d8db699066c1188c71a",
      "fileid": "ac9fbae01c60526537172231ac09a03d17333c421cc44bef06dab2e2b8ff5eff",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/25906779722"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.3-26.1",
      "date": "2026-05-15T08:13:13.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "9bfdad748a2958c02aff9d8db699066c1188c71a",
      "fileid": "44305d1a6d5ac255b1f3b8b8fd12c2567955cfd4cc6493a10b15330b46f331db",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/25906779722"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.3-26.1",
      "date": "2026-05-15T08:12:55.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "9bfdad748a2958c02aff9d8db699066c1188c71a",
      "fileid": "1e9bf952c5d446171eece8b4ba2cf0203dd3c91ff6c2e9ccecdde0142077b757",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/25906779722"
    }
  ]
}