How is ODBC used in various programming languages?

How is ODBC used in various programming languages?

ODBC, or Open Database Connectivity, is a standard API for accessing database management systems. It allows different programming languages to connect to databases using a common interface.

Can you give examples of how to use ODBC in Python?

Sure! In Python, you can use the pyodbc library to connect to an ODBC data source. Here's a simple example:

import pyodbc

# Define your connection string
conn = pyodbc.connect('DSN=DataSourceName;UID=user;PWD=password')

# Create a cursor object
cursor = conn.cursor()

# Execute a query
cursor.execute('SELECT * FROM table_name')

# Fetch results
for row in cursor:
    print(row)

What about using ODBC in Java?

In Java, you can use the JDBC-ODBC Bridge to connect to ODBC data sources. Here's a basic example:

import java.sql.*;

public class ODBCExample {
    public static void main(String[] args) {
        try {
            // Load the ODBC driver
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            // Establish a connection
            Connection con = DriverManager.getConnection("jdbc:odbc:DataSourceName", "user", "password");
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM table_name");
            while (rs.next()) {
                System.out.println(rs.getString(1));
            }
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}