# Odbc

> R odbc package for ODBC database connections. Use for connecting to any ODBC-compatible database.

- Skill: `leolin990405/odbc` (Agent Skill)
- Install (CLI): `npx get-skill add leolin990405/odbc`
- Raw SKILL.md: https://api.skillmd.com/api/skills/leolin990405/odbc/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: LeoLin990405 (https://skillmd.com/u/leolin990405)
- Updated: 2026-11-14
- Page: https://skillmd.com/skills/leolin990405/odbc

---


# odbc Package

ODBC database connections.

## Connect

```r
library(DBI)
library(odbc)

# DSN connection
con <- dbConnect(odbc(), dsn = "MyDSN")

# Connection string
con <- dbConnect(odbc(),
  Driver = "SQL Server",
  Server = "server.example.com",
  Database = "mydb",
  UID = "user",
  PWD = "password"
)

# List available drivers
odbcListDrivers()

# List DSNs
odbcListDataSources()
```

## SQL Server

```r
con <- dbConnect(odbc(),
  Driver = "ODBC Driver 17 for SQL Server",
  Server = "server.example.com",
  Database = "mydb",
  UID = "user",
  PWD = "password",
  Port = 1433
)
```

## MySQL/MariaDB

```r
con <- dbConnect(odbc(),
  Driver = "MySQL ODBC 8.0 Driver",
  Server = "localhost",
  Database = "mydb",
  UID = "user",
  PWD = "password"
)
```

## Basic Operations

```r
# Query
df <- dbGetQuery(con, "SELECT * FROM table")

# Write
dbWriteTable(con, "new_table", df)

# Execute
dbExecute(con, "UPDATE table SET col = 'value'")
```

## Disconnect

```r
dbDisconnect(con)
```

