> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pads4.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Connecting a Database via ODBC

**ODBC (Open Database Connectivity)** is a widely used method for accessing various **industry-standard databases**. Many database manufacturers support **ODBC drivers** to enable seamless connectivity.

**Key Differences Between ODBC and OLEDB:**

* **ODBC** has **less overhead**, making it more **lightweight and efficient**.
* **OLEDB** offers **more functionality**, but with increased overhead.

***

## **Prerequisites**

Before setting up an **ODBC connection** in **PADS4**, ensure:

* The **ODBC driver** for the required database **is installed** on your system.
* The **database is accessible** from the **PADS4 Data Server** or **local machine**.

***

## **Steps to Add/Modify an ODBC Connection in PADS4**

### **1. Start the Data Provider Wizard**

* Follow the steps outlined in **Adding a Data Provider** or **Editing a Data Provider**.
* Select **ODBC** as the provider type.

### **2. Enter the ODBC Connection String**

* Provide the **ODBC connection string** to establish a link with your database.
* The format of this string depends on the **ODBC driver** in use.
* Visit [www.connectionstrings.com](https://www.connectionstrings.com) for reference.

#### **Example Connection String for Microsoft Access**

```plaintext theme={null}
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\MyDatabase.accdb;Uid=Admin;Pwd=;
```

* Click **Test** to validate the connection.
* Click **Next** to proceed.

***

### **3. Select the Data Source**

* Choose one of the detected data sources:
  * **Tables**
  * **Views**
  * **Stored Procedures**
* If no predefined data sources are available, choose **SQL Statement** and manually enter an **SQL query**.

#### **Example SQL Query**

```sql theme={null}
SELECT * FROM Customers
```

**Tip:**\
Only use **SQL statements** when necessary. Manually written queries need to be validated during execution, which may **affect performance**.

* Click **Next** to continue.

***

### **4. Complete the Setup**

* Follow the remaining steps in the **Adding a Data Provider** guide.
* Click **Finish** to save the connection settings.

***

## **Important Considerations**

* **Ensure Network Access:**
  * If using a **PADS4 Data Server**, the **ODBC driver must be installed** on the **server**, and the database **must be accessible**.
  * If **not using a Data Server**, ensure that **each PADS4 Viewer and Designer** has the **correct ODBC driver installed**.

* **Testing the Connection:**
  * Use the **Test** button to verify the connection **before proceeding**.

* **Performance Considerations:**
  * Use **predefined Tables, Views, or Stored Procedures** for **better performance** instead of raw **SQL queries**.

By following these steps, you can successfully **connect an ODBC database to PADS4** and retrieve **real-time data** for **digital signage and automated content updates**.